MCITP - 70-444 - Optimizing and Maintaining a Database Administration Solution Using Microsoft SQ.pdf - Certyfikaty MS - SacrA

PUBLISHED BY

Microsoft Press

A Division of Microsoft Corporation

One Microsoft Way

Redmond, Washington 98052-6399

any means without the written permission of the publisher.

ISBN-13: 978-0-7356-2254-8

ISBN-10: 0-7356-2254-X

Library of Congress Control Number 2006932077

Printed and bound in the United States of America.

1 2 3 4 5 6 7 8 9 QWT 0 9 8 7 6 5

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information

about international editions, contact your local Microsoft Corporation office or contact Microsoft Press Inter-

national directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send comments

to tkinput@microsoft.com.

Microsoft, Microsoft Press, Active Directory, ActiveX, BizTalk, Excel, Internet Explorer, JScript, MSDN,

Visual Basic, Visual C++, Visual C#, Visual J#, Visual SourceSafe, Visual Studio, Windows, Windows NT,

and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United

States and/or other countries. Other product and company names mentioned herein may be the trademarks of

their respective owners.

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and

events depicted herein are fictitious. No association with any real company, organization, product, domain

name, e-mail address, logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided with-

out any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers,

or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly

by this book.

Acquisitions Editor: Ken Jones

Project Editor: Laura Sackerman

Technical Editors: Rozanne Murphy Whalen and Dan Whalen

Indexer: William Meyers

Copy Editor: Roger LeBlanc

Body Part No. X12-48798

For Oksana and Rooslan: I love you.

Orin Thomas

To my daughter-in-law, Harjit, and my son-in-law, James,

both of whom chose to become related to me of their own free will.

Ian McLean

Contents at a Glance

1 Troubleshooting Database and Server Performance . . . . . . . . . . . . . . . . . .1

2 Analyzing Queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

3 Failure Diagnosis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155

4 Disaster Recovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193

5 Performance Monitoring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249

6 Database Maintenance. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 303

7 SQL Server Integration Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 367

8 Design Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 419

9 Business Requirements. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 453

10 Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 523

11 Security Strategies. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 583

12 Detecting and Responding to Attacks . . . . . . . . . . . . . . . . . . . . . . . . . . . 647

Appendix . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 675

vii

MCITP - 70-444 - Optimizing and Maintaining a Database Administration Solution Using Microsoft SQ.pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: