SQL Server Policy-Based Management

This blog is dedicated to Policy-Based Management introduced in SQL Server 2008

July, 2008

  • SQL Server Policy-Based Management

    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...
  • SQL Server Policy-Based Management

    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...
  • SQL Server Policy-Based Management

    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...
  • SQL Server Policy-Based Management

    Using PBM Against SQL2K and SQL2K5

    We get this question a lot: can I use PBM against a SQL2K & SQL2K5 instances. The quick answer is yes but in a limited fashion. PBM is ultimately based on SMO (SQL Server Management Objects) and SMO supports SQL2K, SQL2K5, and SQL2K8. PBM relies on...
  • SQL Server Policy-Based Management


    One of the key development tenets of Policy-Based Management was to raise the level of abstraction of management. The analogy I've used time and time again is Security Zones in Internet Explorer. Prior to Security Zones we had to scroll through pages...
Page 1 of 1 (5 items)