Pro SQL Server 2008 Policy-Based Management- P1

Pro SQL Server 2008 dựa trên chính sách quản lý là rất quan trọng cho các quản trị cơ sở dữ liệu tìm kiếm kiến thức chuyên sâu về quản lý các máy chủ bằng cách sử dụng dựa trên chính sách quản lý các tính năng mới được giới thiệu trong SQL Server 2008. Cuốn sách này sẽ bao gồm mọi thứ từ giới thiệu một cách cơ bản để quản lý dựa trên chính sách để tạo ra các chính sách riêng của bạn để thực thi các quy tắc nhất quán trong toàn tổ chức của bạn...
Nội dung trích xuất từ tài liệu:
Pro SQL Server 2008 Policy-Based Management- P1THE EXPERT’S VOICE ® IN SQL SERVERProSQL Server 2008Policy-BasedManagement Easily manage large server farms by automating consistent rules and policiesKen Simmons, Colin Stasiuk, and Jorge Segarra Pro SQL Server 2008 Policy-Based ManagementKen SimmonsColin StasiukJorge SegarraPRO SQL SERVER 2008 POLICY-BASED MANAGEMENTCopyright © 2010 by Ken Simmons, Colin Stasiuk, Jorge SegarraAll rights reserved. No part of this work may be reproduced or transmitted in any form or by anymeans, electronic or mechanical, including photocopying, recording, or by any information storage orretrieval system, without the prior written permission of the copyright owner and the publisher.ISBN-13 (pbk): 978-1-4302-2910-0ISBN-13 (electronic): 978-1-4302-2911-7Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1Trademarked names may appear in this book. Rather than use a trademark symbol with everyoccurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit ofthe 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 IshchenkoDistributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6thFloor, 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 rights@apress.com, or visit www.apress.com.Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotionaluse. eBook versions and licenses are also available for most titles. For more information, reference ourSpecial 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 everyprecaution has been taken in the preparation of this work, neither the author(s) nor Apress shall haveany liability to any person or entity with respect to any loss or damage caused or alleged to be causeddirectly 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 answerquestions pertaining to this book in order to successfully download the code. To my wife Susan and son Nathan. – Ken SimmonsFor 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 Contents at a Glance Contents at a Glance.............................................................................................. iv Contents.................................................................................................................. v About the Authors................................................................................................. xii About the Technical Reviewers ........................................................................... xiii Acknowledgments ............................................................................................... xiv Introduction .......................................................................................................... xv Chapter 1: Introduction to Policy-Based Management...........................................1 Chapter 2: Creating Policies .................................................................................13 Chapter 3: Evaluating Policies ..............................................................................49 Chapter 4: Policy-Based Management Using PowerShell.....................................89 Chapter 5: Receiving Alerts for Policy Violations ...............................................109 Chapter 6: Poli ...