Chapter 19. Policy-Based Management

After completing this chapter, you will be able to

  • Define Policy-Based Management

  • Create facets

  • Create conditions

  • Create policies

  • Target policies to instances

  • Check and enforce policies

In this chapter, you will learn how to set up and configure the policy framework new to SQL Server 2008. You will learn how to set up rules to be checked and group those rules into a policy that can be targeted at one or more SQL Server instances. You will also learn how to centralize the validation and enforcement of your policies.

Overview of Policy-Based Management

Prior to SQL Server 2008, configuration management of an environment was accomplished by using “documented sneaker-net.” The configuration options, naming conventions, and ...

Get Microsoft® SQL Server® 2008 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.