How to work with Policy Based Management (PBM)
In my previous article on policy based management I’ve gone through what is policy based management and how it helps administration. Lets discuss about how to work with policy based management i.e. how to create a policy and implement it. To work with a policy we need to first create a condition and we need to use this condition in our policy. Lets discuss each of the title mentioned below
- How to: Create a Policy-Based Management Condition
- How to: Create a Policy-Based Management Policy
- How to: Evaluate a Policy-Based Management Policy
Policy Based Management (PBM)
Introduction:
Policy based management is one of the new feature added from SQL Server 2008. With the help of this feature you can evalute an instance or database or objects to bound with in certain conditions \ policies. If any of the objects or instances failed to bound with in the policy then it can either notified or you can directly change the values to bound within policy with the help of policy management there by making the administration simpler. So by using this feature you don't need to outline all these conditions and no need to have an auditing on the same.
How to change Server Collation in SQL Server 2008
New article posted on changing collation in sql server 2008. You can check the article from the link below.
In this article we are going to discuss about changing SQL Server 2008 collation at serverlevel. While installing SQL Server 2008 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling. Lets discuss the necessary steps for changing collation for sql server.
How to change Server Collation in SQL Server 2005
New article posted on changing collation in sql server 2005. You can check the article from the link below.
In this article we are going to discuss about changing SQL Server 2005 collation at serverlevel. While installing SQL Server 2005 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling.
Policy Based Management – SQL Server 2008
New article on "Policy Based Management" is posted in our main website. Check the article from the link given below.
This article discusses the new feature named Policy Based Management in SQL Server 2008. Policy Based Management is an extensive management configuration that can be used to manage servers, databases and objects. Policy Based framework provides a way to define policies that apply to servers, databases and objects. With Policy based Management framework, you can enforce consistent policies across all servers.