E-Book Content
BOOKS FOR PROFESSIONALS BY PROFESSIONALS ®
Pro Server 2008 Policy-Based Management Dear Reader,
Ken Simmons, Author of Pro SQL Server 2008 Mirroring Pro SQL Server 2008 Administration
Colin Stasiuk
Enforcing standards across your organization has always been a difficult task when it comes to SQL Server. Yet the growing compliance requirements for today’s organizations make it more important than ever to ensure that your servers are properly configured. Policy-Based Management could be your salvation. It is a new feature in SQL Server 2008 enabling you to manage large groups of servers with consistency, in compliance with company rules and government regulation. Policy-Based Management is so important that we wrote this book to provide a central source of deep information to help you implement the feature in your environment. We cover practical scenarios and give guidance to help you with your compliance needs. You’ll learn to: • Maintain a consistent, predictable environment throughout your organization • Create and evaluate policies to ensure that consistency • Configure and receive alerts for policy violations • View the state of your policies through reports and online queries • Implement policies to help meet compliance regulations We aim to provide you with the knowledge to make the right decisions when deploying policies in your environment, as well to provide a quick reference guide to have at your fingertips on a daily basis. We know that 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 confidence and peace of mind from knowing that your environment is the way it should be. Ken Simmons, Colin Stasiuk, Jorge Segarra
Companion eBook Available
Pro SQL Server 2008 Policy-Based Management
FPO
THE EXPERT’S VOICE ® IN SQL SERVER
THE APRESS ROADMAP Beginning SQL Server 2008 Administration DBA Survivor: Become A Rock Star DBA
www.apress.com Shelve in: Databases / SQL Server User level: Intermediate–Advanced
Pro SQL Server 2008 Administration
Pro SQL Server 2008 Policy-Based Management SQL Server 2008 Query Performance Tuning
Simmons Stasiuk Segarra
SOURCE CODE ONLINE
Policy-Based Management Easily manage large server farms by automating consistent rules and policies
Jorge Segarra
Companion eBook
Pro SQL Server 2008
Ken Simmons, Colin Stasiuk, and Jorge Segarra
Pro SQL Server 2008 Policy-Based Management
Ken Simmons Colin Stasiuk Jorge Segarra
PRO SQL SERVER 2008 POLICY-BASED MANAGEMENT Copyright © 2010 by Ken Simmons, Colin Stasiuk, Jorge Segarra All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. ISBN-13 (pbk): 978-1-4302-2910-0 ISBN-13 (electronic): 978-1-4302-2911-7 Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1 Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. President and Publisher: Paul Manning Lead Editor: Jonathan Gennick Technical Reviewer: Thomas LaRock Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Gennick, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes, Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, D