Designing Policy Based Management in Microsoft SQL Server 2008
- By Mike Hotek
Prior to Microsoft SQL Server 2008, you performed configuration management of an environment by using a conglomeration of documents, scripts, and manual checking. The configuration options, naming conventions, and allowed feature set were outlined in one or more documents. To enforce your standards, you would have had to connect to each instance and execute scripts that needed to be maintained and updated with new versions and service packs. In this chapter, you learn about the new Policy Based Management framework that allows you to check and enforce policy compliance across your entire SQL Server infrastructure.
Exam objectives in this chapter:
Implement the declarative management framework (DMF).
Configure surface area.
Lesson in this chapter:
Lesson 1: Designing Policies
Before You Begin
To complete the lessons in this chapter, you must have:
SQL Server 2008 installed
The AdventureWorks database installed within the instance