In this SQL Server 2012 article I will describe what are policy based management facets and show you a list of them, later on I will give a link that will show you when I used it and how to use it. For the purpose of this article I will use SQL Server 2012.
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- Policy based management (facets) are not available in SQL Server 2005.
Who is it for?
- People who would like to learn basics of using facets (policy based management)
- Those who are preparing for Microsoft certifications and need to cover this topic.
Prior knowledge. If you are new to SQL Server Policy based management than you might find links below useful when reading this article:
What are SQL Server facets
Policy Based Management Facet is an object with a collection of properties (facet properties) that represent SQL Server object that you can manage.
Below are several screenshots that show how to view facets and entire list of SQL Server 2012 facets in policy based management folder.
Recently I have written a blog post about an issues with cast date and cast datetime that give different result for the same input value depending on Login Language. One of the solutions is to ensure that every existing login default language is set to 'English' (instead of for instance British).
In order to accomplish it I will use Login facet and Language Property (see below) and than set a condition using login facet.
You can follow next article that shows how to create a condition