Introduction

Microsoft made database administrators very happy by introducing a feature called Policy-based Management (PBM). PBM helps administrators to manage one or more instances of SQL Server and manage database entities and/or other SQL Server objects, based on the policy defined in PBM. It helps DBAs to apply/enforce policies for server objects and databases, or to manage different tasks effortlessly and effectively.

The following terms will be needed in the recipes coming up in this chapter, so keep them in mind to ensure that you can understand all the recipes properly:

• Policies: Defined rules for the database or server objects under Policy-Based Management

• Conditions: A condition is a Boolean value that shows the status of facets

• Facets: A set of properties that models the behavior of a target in Policy-Based Management

Note

A few years ago, when I visited a small company, I observed that there were no rules defined for naming conventions. All the user stored procedures in that...