Designing Policy Based Management in Microsoft SQL Server 2008

  • 2/18/2009
In this chapter from MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance, learn about the new Policy Based Management framework that allows you to check and enforce policy compliance across your entire SQL Server infrastructure.

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