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) {     

Facets

The American Heritage Dictionary of the English Language (Fourth Edition) defines facet as: One of numerous aspects, as of a subject . The definition of Aspect (from the same dictionary) is: Appearance to the eye, especially from a specific vantage point

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