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...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm Date: 09/11/2008
Out-Of-Box Policies
SQL Server 2008 includes several predefined policies. These are generally associated with best...
Author: sqlpbm Date: 07/15/2008
Policy Categories
Policy categories have two purposes in SQL2K8: 1) organization of policies and 2) policy scope. In...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm Date: 07/04/2008
ExecuteSql()
One of the key development tenets of Policy-Based Management was to raise the level of abstraction...
Author: sqlpbm Date: 07/03/2008
APBMB
Another PBM Blog (APBMB)! Lara Rubbelke has been blogging a bunch about PBM. Check out her blog...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm Date: 06/14/2008
Facets
The American Heritage Dictionary of the English Language (Fourth Edition) defines facet as: One of...
Author: sqlpbm 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...
Author: sqlpbm 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...
Author: sqlpbm Date: 04/20/2008
Welcome
Well hello there and welcome to the SQL Server blog devoted to Policy-Based Management - PBM. PBM, a...
Author: sqlpbm Date: 04/08/2008