In this chapter we will cover:
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: