Pro SQL Server 2008 Policy-Based Management

by Ken Simmons, Colin Stasiuk, Jorge Segarra

Overview

Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization.

• Provides in-depth treatment of policy-based management in a single source
• Provides practical usage scenarios for policy-based management
• Provides guidance to help meet growing regulatory compliance needs

Product Details

ISBN-13:	9781430229100
Publisher:	Apress
Publication date:	05/03/2010
Series:	Expert's Voice in SQL Server
Edition description:	1st ed.
Pages:	268
Product dimensions:	7.40(w) x 9.20(h) x 0.80(d)

About the Author

Ken Simmons is a database administrator and developer specializing in Microsoft SQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005. Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed an SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, Florida.

Table of Contents

• Introduction to Policy-Based Management
• Creating Policies
• Evaluating Policies
• Policy-Based Management Using PowerShell
• Receiving Alerts for Policy Violations
• Policy-Based Management Internals
• Practical Uses of Policy-Based Management
• Reporting
• Enforcing Compliance
• Where to Go from Here