Policy Management
-
SSWUG and PBM
On September 7th, 2011 at 1pm Central Time the SQL Server Worldwide User Group will be airing my presentation on how to Manage your shop with CMS and PBM. The webcast is free for SSWUG members and $29 for non-members. As an added bonus, I will be in the live chat room ready to answer…
-
PBM Import Options
When you import policies into your Policy Based Management Server you have two options. The first option is “Replace duplicates with items imported”. This option will replace any policies in your PBM server that have the same name as the one you are importing. This can come in handy if you have to make a…
-
Speaking at PASS DBA Virtual Chapter
I will be speaking for the PASS DBA Virtual Chapter on August 24th, 2011 at 11AM CT. I will be delivering my presentation on Central Management Server and Policy Based Management. If you have not checked out the virtual chapters that PASS has, then you need to Go Check Them Out. These chapters are designed to fill…
-
Understanding PBM Terminology
I get a lot of questions about the terminology surrounding PBM. Here is a list of the terms you will want to become familiar with along with a description. Facet – These are a grouping of properties based on a feature or particular aspect of SQL Server. Be sure to look through these after you enable…
-
Speaking at SQLSaturday #90
I will be speaking at SQLSaturday #90 in Oklahoma City on August 27th, 2011. I will be delivering my presentation on Central Management Server and Policy Based Management. I’m looking forward to this event since I lived in the western Oklahoma City suburb of Yukon for about 5 years. I’m hoping to visit some of…
-
What is Policy Based Management
Policy Based Management gives us centralized management of our SQL Servers. It allows us to evaluate, configure, and enforce standards across the enterprise. If you are familiar with Active Directory Group Policy Objects then you will see a direct resemblance between the two technologies. PBM allows us to create rules for our SQL Servers so…
-
Speaking at Dallas TechFest
I will be presenting two sessions at Dallas TechFest! I am honored and excited to be speaking. Dallas TechFest is a premiere technology conference that includes many technology areas like .Net, Java, Windows Phone, and of course SQL Server. This year the conference has grown and expanded from one day to two days, and is…
-
Why My Policy will not Evaluate System DBs
Do you have a policy that is supposed to include “Every Database” as part of its condition, but for some reason it never includes the system databases? The “Every” condition is a built-in condition that cannot be changed and does not include system databases. If you want to include the system databases in your policy you…
-
syspolicy_purge_history Job Fails
The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists of the following three steps. First to check to see if PBM is enabled and exit if it is not. Run the msdb.dbo.sp_syspolicy_purge_history system stored procedure to clear the history Use…
-
SQL Naming Conventions with PBM – SPs
How to enforce a stored procedure naming convention with policy based management.