Pro SQL Server 2022 Administration: A Guide for the Modern DBA

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

P. A. CarterPro SQL Server 2022 Administrationhttps://doi.org/10.1007/978-1-4842-8864-1_24

24. Policy-Based Management

Peter A. Carter¹  

(1)

SOUTHAMPTON, UK

 

Policy-Based Management (PBM) is a system DBAs can use to report on or enforce standards across the enterprise, when used with a Central Management Server. This chapter first introduces you to the concepts used by PBM and then demonstrates how to use PBM to effectively manage an estate through the GUI and with PowerShell.

PBM Concepts

Policy-Based Management uses the concepts of targets, facets, conditions, and policies. Targets are entities PBM manages, such as databases or tables. Facets are collections ...