SQL Server Policy-Based Management
This blog is dedicated to Policy-Based Management introduced in SQL Server 2008
Why does a property show up in > 1 facet? Why do some facets support CoC:Prevent, but others not?
Last week, Shaun Stuart posted some questions on his blog about PBM "strangeness". He was wondering...
Date: 08/13/2010
After renaming computer, "check on schedule" policies don't work. How to fix ...
Hi, If you rename your computer, then "check on schedule policies" won't work because the old...
Date: 08/02/2010
Clarification around "Data and Log Files ..." and "Backup Files ..." policies
Hi, We ship these two Best Practices policies Place Data and Log Files on Separate Drives Backup...
Date: 08/02/2010
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...
Date: 04/20/2009
Policy Evaluation Modes
I hosted a PBM break out session in Microsoft MVP Summit 2009 in March. One feedback I got is that...
Date: 04/13/2009
Defining Complex Server "Health" Policies in SQL2K8
Bart Duncan (a dev on the manageability team and one of the masterminds behind the Management Data...
Date: 09/11/2008
Out-Of-Box Policies
SQL Server 2008 includes several predefined policies. These are generally associated with best...
Date: 07/15/2008
Policy Categories
Policy categories have two purposes in SQL2K8: 1) organization of policies and 2) policy scope. In...
Date: 07/07/2008
Wide Format
You may notice I've changed the blog format from narrow to wide. I think this makes it more readable...
Date: 07/06/2008
Using PBM Against SQL2K and SQL2K5
We get this question a lot: can I use PBM against a SQL2K & SQL2K5 instances. The quick answer...
Date: 07/04/2008
ExecuteSql()
One of the key development tenets of Policy-Based Management was to raise the level of abstraction...
Date: 07/03/2008
APBMB
Another PBM Blog (APBMB)! Lara Rubbelke has been blogging a bunch about PBM. Check out her blog...
Date: 06/18/2008
PowerShell Script for Creating a Policy to a File
Sethu Srinivasan, a developer on the PBM team, wrote a blog post for a sample PowerShell script that...
Date: 06/18/2008
Running Against SQL Server 2005 and SQL Server 2000
@ TechEd SQL Server MVP Peter DeBetta and I presented a session where we created a PowerShell script...
Date: 06/14/2008
Facets
The American Heritage Dictionary of the English Language (Fourth Edition) defines facet as: One of...
Date: 05/24/2008
Creating A Policy With the GUI
In the previous posting we introduced the main PBM concepts through the use of a sample policy: All...
Date: 04/26/2008
Policy-Based Management Overview
This posting provides an overview of Policy-Based Management (PBM). You can read more about PBM in...
Date: 04/20/2008
Welcome
Well hello there and welcome to the SQL Server blog devoted to Policy-Based Management - PBM. PBM, a...
Date: 04/08/2008