Configure and Manage Policy Based Management in SQL Server 2008

July 22, 2008

[From SQL Server Performance]

SQL Server 2008 introduces a new feature called Policy Based Management (aka Declarative Management Framework (DMF)). Database Administrators have always had a tough time to make sure that all the SQL Servers they administer are configured according to the policies and standards of organization. Using the Policy Based Management feature DBA’s can now manage one or more instances of SQL Server 2008 an check for policy compliance or non compliance issues. The policies can be created to manage all the entities of SQL Server 2008, such as SQL Server Configurations, Databases, Tables, Users, Roles, or any other SQL Server objects etc.

The article continues at http://sql-server-performance.com/articles/dba/Configure_and_Manage_Policy_Based_Management_in_SQL_Server_2008_p1.aspx