Policy-Based Management(PBM) is the expansion of advanced DDL trigger mechanisms on the Server. Think of the following things
a. How do I allow the users to create the table in specific naming conditions like starting only with ‘T’?
b. How about checking the availability of the latest Sql Server backups?
c. How about limiting the number of CPU in a sql server?
Yes there are countless of server management applications with the PBM.Each POLICY is based on a CONDITION and each CONDITION decides the state of a specific target(like databases,tables,stored procedures etc.) with respect to a particular FACET.
There are a list of builtin policies available on the Sql server 2008 by default. They can be imported from the following location C:\Program Files\Microsoft SQL Server\100\Tools\Policies. All the policies can be imported and exported as they are configured in XML.The Developers can themselves create their own facets depending on their Organisation policies.
More on application of policies coming soon..
