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 why some properties like “AutoClose” show up in more than one facet, and then why some of those facets support “check on change : prevent” but others don’t. I’ve reproduced my answer to Shawn, below … A property can appear…

1

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 machine name is embedded in the SQL Agent jobs. To make this (and a lot of other stuff) work after a machine rename, execute the following procedure:  “How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL…

0

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 Files Must Be on Separate Devices from the Database Files Unfortunately, neither of those two policies can detect separate physical devices through Windows mount points.   We will clarify the documentation on this and look to get this working across…

0

Clarification on the "Guest Permissions on User Databases" policy

We ship a “Microsoft Best Practices: Security” policy called “Guest Permissions on User Databases“.  Unfortunately, the wording in the UI and BOL is not clear about whether this can/should apply to msdb.   Here is what is says today: “You can do this by executing REVOKE CONNECT FROM GUEST” from within any database other than master…

0

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 their properties. He has posted the list on his blog. Below is the code snippet from Jens: foreach (FacetInfo info in PolicyStore.Facets) {      Console.WriteLine(info.Name);      foreach (System.Reflection.PropertyInfo p in info.FacetProperties)      {           Console.WriteLine("\t" + p.Name);…

1

Policy Evaluation Modes

I hosted a PBM break out session in Microsoft MVP Summit 2009 in March. One feedback I got is that the rules for what evaluation modes a policy support are obtuse. I thought that would be a good topic to cover in the blog. In PBM, users can specify the “Evaluation Mode” for a policy,…

2

Defining Complex Server "Health" Policies in SQL2K8

Bart Duncan (a dev on the manageability team and one of the masterminds behind the Management Data Warehouse and Data Collector feature in SQL Server 2008) has a blog posting where he walks through using PBM to author a complex server "health" policy.

1

Out-Of-Box Policies

SQL Server 2008 includes several predefined policies. These are generally associated with best practices and overtime the rules from the Best Practices Analyzer will be implemented as policies for PBM. A number of these have already been implemented and are available to you in one of two forms: First, they’re installed as part of every…

5

Policy Categories

Policy categories have two purposes in SQL2K8: 1) organization of policies and 2) policy scope. In this posting we’ll explore creating categories for each of these purposes. Creating Categories There are two ways to create a category: 1) the Manage Categories dialog and 2) The Policy Properties dialog. To create a category from the Manage…

1

Wide Format

You may notice I’ve changed the blog format from narrow to wide. I think this makes it more readable as it uses more screen real estate – less scrolling! Let me know what you think. Or let me know if you think I’m obsessing too much about something insignificant and I should be directing that…

1