Using Policy Based Management

Policy Based Management (PBM) was introduced in SQL Server 2008 and was named Declarative Management Framework in the early days of SQL Server 2008 development. These names say it all. With BPM, you declare policies to check or enforce on one or many SQL Servers. It is a wonderful tool to keep your server consistently configured or to enforce rules such as naming conventions or database options. BPM is only available in Enterprise edition.

How to do it...

  1. In SSMS Object Explorer, open the Management node and the Policy Management node. Right-click on New Policy...:
    How to do it...
  2. In the Create New Policy window, enter a name for your ...

Get Microsoft SQL Server 2012 Security Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.