Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Pro SQL Server 2008 Policy Based Management

By:   |   Read Comments (1)   |   Related Tips: More > Professional Development Books

ALERT: Did you know 66% of DBAs say their workload is increasing! - Click here to learn more.


Enforcing standards across your organization has always been a difficult task when it comes to SQL Server. With the introduction of Policy-Based Managment in SQL Server 2008, enforcing standards is a much easier task. Like anything new, finding information, examples and best practices is not always that easy.


Enforcing standards across your organization has always been difficult and with the growing compliance requirements for today's organizations, it is more important than ever to ensure that your servers are properly configured. Policy-Based Management is a key component in any infrastructure where you want to maintain standards and consistency across one or more SQL Servers. Pro SQL Server Policy-Based Management covers the full spectrum of Policiy-Based Management, taking you from the planning phase through the implementation to the maintenance phase and beyond.

Pro SQL Server Policy-Based ManagementThis book introduces you to the basic concepts of Policy-Based Management as well as covering advanced topics you need to know in order to enforce consistent rules across your organization.

Chapter 1 provides you with an overview of Policy-Based Management and introduces you to the concepts of many of the topics we will cover throughout the rest of the book.

Chapter 2 covers the many different options you have in order to create conditions and policies including how to categorize policies to ease administration.

Chapter 3 explains the different evaluation modes and walks you through the steps you need to know in order to evaluate and schedule policies.

Chapter 4 shows you how you can extend the evaluation features offered in Policy-Based Management by using PowerShell.

Chapter 5 covers everything you need to know in order to receive an alert when a policy fails including setting up Database Mail, creating an operator, and creating alerts on the appropriate conditions.

Chapter 6 covers the tables, stored procedures, and system views in the msdb database where the Policy-Based Management information is stored as well as the roles and permissions required to use Policy-Based Management.

Chapter 7 shows you how you can take advantage of the Enterprise Policy Management Framework as a central reporting tool for Policy-Based Management.

Chapter 8 provides you with some practical uses for Policy-Based Management by using a combination of Microsoft best practice policies and custom policies.

Chapter 9 addresses how you can use Policy-Based Management to meet the compliance needs of your organization.

Chapter 10 discusses the various resources you have to help you continue learning Policy-Based Management as well as the support options you have if you need further assistance.

Pro SQL Server Policy-Based Management will provide you with the knowledge you need to make the right decisions when deploying policies in your environment as well as a quick reference guide to have at your fingertips. Maintaining a stable and consistent SQL Server environment can be overwhelming at times; however, having the proper configurations in place, and ensuring those configurations remain consistent by using Policy-Based Management will give you the confidence and peace of mind knowing that your environment is the way it should be.

Next Steps

Last Update:

next webcast button

next tip button

About the author
MSSQLTips author Ken Simmons Ken Simmons is a database administrator, developer, SQL Server book author and Microsoft SQL Server MVP.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Saturday, March 19, 2011 - 3:54:05 PM - Antony Back To Top

   Your book looks nice.....need to find the time to read it.



Learn more about SQL Server tools