Partager via


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