Pro SQL Server 2008 Policy Based Management
By: Ken Simmons | Comments (1) | Related: More > Professional Development Books
Problem
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.
Solution
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.
This 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
- Review more tips on Policy-Based Management
- Get a copy of Pro SQL Server 2008 Policy-Based Management
About the author
Ken Simmons is a database administrator, developer, SQL Server book author and Microsoft SQL Server MVP.
View all my tips