SQL Server Policy-Based Management

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

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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 some changes to the DB engine which are not available...
  • Blog Post: Creating A Policy With the GUI

    In the previous posting we introduced the main PBM concepts through the use of a sample policy: All stored procedures in the database must start with "usp_". In this posting we will walk through the creation of that policy using the PBM GUI accessible from SQL Server Management Studio (SSMS...
Page 1 of 1 (3 items)