SQL Server Policy-Based Management

Generate the List of All Available Facets and Their Properties

Our colleague Jens Suessmeyer in Germany has figured out how to generate the list of all facets and their properties. He has posted the list on his blog. Below is the code snippet from Jens: foreach ( FacetInfo info in PolicyStore .Facets) {     

Policy-Based Management Overview

This posting provides an overview of Policy-Based Management (PBM). You can read more about PBM in SQL Server 2008 Books On-line . Many of the ad hoc problems DBAs experience are caused by unwanted configuration changes or configuration changes that don't