Search This Blog

SQL Server 2008 Top New Features : Policy-Based Management

Policy-Based Management enables the efficient management of multiple SQL Server instances from a single location. Easily create policies that control security, database options, object naming conventions, and other settings at a highly granular level. Policies can evaluate servers for compliance with a set of predefined conditions and prevent undesirable changes being made to servers.

  • Management is centralized, thereby reducing the need to configure each server separately

  • Administration is simplified, reducing the effort required to maintain standardization and compliance, even in complex environments

  • Configuration is straightforward and can be done entirely within SQL Server Management Studio

  • Out-of-the-box predefined policies make it easy to get started

  • Backwards compatibility supports managing instances of SQL Server 2008, SQL Server 2005, and SQL Server 2000