Tài liệu Pro SQL Server 2008 Policy-Based Management- P1 doc

Segarra

Stasiuk

Simmons

Pro SQL Server 2008 Policy-Based Management

THE EXPERT’S VOICE® IN SQL SERVER

Pro

SQL Server 2008

Policy-Based

Management

Ken Simmons, Colin Stasiuk, and Jorge Segarra

Companion

eBook

Available

Easily manage large server farms by

automating consistent rules and policies

BOOKS FOR PROFESSIONALS BY PROFESSIONALS®

Pro Server 2008

Policy-Based Management

Dear Reader,

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, hav￾ing 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

Shelve in:

Databases / SQL Server

User level:

Intermediate–Advanced

FPO

Ken Simmons, Author of

Pro SQL Server 2008

Mirroring

Pro SQL Server 2008

Administration

Colin Stasiuk

Jorge Segarra

www.apress.com

SOURCE CODE ONLINE

Companion eBook

THE APRESS ROADMAP

Beginning

SQL Server 2008

Administration

DBA Survivor:

Become A Rock Star DBA

Pro

SQL Server 2008

Policy-Based Management

SQL Server 2008

Query Performance Tuning

Pro

SQL Server 2008

Administration

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

Pro SQL Server 2008

Policy-Based

Management

„„„

Ken Simmons

Colin Stasiuk

Jorge Segarra

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

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, Dominic Shakeshaft,

Matt Wade, Tom Welsh

Coordinating Editor: Kelly Moritz

Copy Editor: Marilyn Smith

Compositor: Bytheway Publishing Services

Indexer: John Collin

Artist: April Milne

Cover Designer: Anna Ishchenko

Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th

Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer￾sbm.com, or visit www.springeronline.com.

For information on translations, please e-mail [email protected], or visit www.apress.com.

Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional

use. eBook versions and licenses are also available for most titles. For more information, reference our

Special Bulk Sales–eBook Licensing web page at www.apress.com/info/bulksales.

The information in this book is distributed on an “as is” basis, without warranty. Although every

precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have

any liability to any person or entity with respect to any loss or damage caused or alleged to be caused

directly or indirectly by the information contained in this work.

The source code for this book is available to readers at www.apress.com. You will need to answer

questions pertaining to this book in order to successfully download the code.

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.

To my wife Susan and son Nathan.

– Ken Simmons

For Robbie and Lana, who always put a smile on my face, and for Heather, whose policies always keep me in

check.

– Colin Stasiuk

I’d like to dedicate this book to my wife, Jessica. Without your love, understanding, and support, I wouldn’t

have been able to do this. I love you always and forever.

– Jorge Segarra

Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark.