Microsoft_SQL_Server_2008_R2_Unleashed.dlebooks.com.pdf

Ray Rankins

Paul Bertucci

Chris Gallelli

Alex T. Silverstein

Microsoft ®

SQL Server

2008 R2

UNLEASHED

800 East 96th Street, Indianapolis, Indiana 46240 USA

Microsoft SQL Server 2008 R2 Unleashed

system, or transmitted by any means, electronic, mechanical, photocopying, recording,

or otherwise, without written permission from the publisher. No patent liability is

assumed with respect to the use of the information contained herein. Although every

precaution has been taken in the preparation of this book, the publisher and author

assume no responsibility for errors or omissions. Nor is any liability assumed for

damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-33056-8

ISBN-10: 0-672-33056-3

Library of Congress Cataloging-in-Publication Data is on file.

Publisher

Paul Boger

Editor In Chief

Karen Gettman

Acquisitions Editor

Neil Rowe

Development Editor

Mark Renfrow

Managing Editor

Sandra Schroeder

Printed in the United States of America

First Printing September 2010

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks

have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of

this information. Use of a term in this book should not be regarded as affecting the

validity of any trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possi-

ble, but no warranty or fitness is implied. The information provided is on an “as is”

basis. The author(s) and the publisher shall have neither liability nor responsibility to

any person or entity with respect to any loss or damages arising from the information

contained in this book or from the use of the CD or programs accompanying it.

Bulk Sales

Pearson offers excellent discounts on this book when ordered in quantity for bulk

purchases or special sales. For more information, please contact:

U.S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact:

International Sales

+1-317-581-3793

international@pearsontechgroup.com

Project Editor

Seth Kerney

Copy Editor

Chuck Hutchinson

Indexer

Erika MIllen

Proofreader

Leslie Joseph

Debbie Williams

Technical Editor

Rebecca M. Riordan

J. Boyd Nolan

Publishing

Coordinator

Romney French

Multimedia Developer

Dan Scherf

Designer

Gary Adair

Compositor

Mark Shirar

Contents at a Glance

Introduction....................................................................................................1

Part I

Welcome to Microsoft SQL Server

SQL Server 2008 Overview..............................................................................9

What’s New in SQL Server 2008 ...................................................................35

Examples of SQL Server Implementations ...................................................51

Part II

SQL Server Tools and Utilities

SQL Server Management Studio ...................................................................63

SQL Server Command-Line Utilities ..........................................................103

SQL Server Profiler ......................................................................................121

Part III

SQL Server Administration

SQL Server System and Database Administration......................................165

Installing SQL Server 2008..........................................................................185

Upgrading to SQL Server 2008 ...................................................................227

Client Installation and Configuration .......................................................263

Security and User Administration ..............................................................291

Data Encryption ..........................................................................................335

Security and Compliance............................................................................359

Database Backup and Restore .....................................................................377

Database Mail..............................................................................................427

SQL Server Scheduling and Notification ....................................................449

Administering SQL Server 2008 with PowerShell ......................................481

SQL Server High Availability ......................................................................523

Replication ..................................................................................................545

Database Mirroring .....................................................................................617

SQL Server Clustering .................................................................................655

Administering Policy-Based Management..................................................687

Part IV

Database Administration

Creating and Managing Databases .............................................................709

Creating and Managing Tables ...................................................................741

Creating and Managing Indexes ................................................................791

Implementing Data Integrity......................................................................811

Creating and Managing Views in SQL Server ............................................837

Creating and Managing Stored Procedures ................................................869

Creating and Managing User-Defined Functions. .....................................917

Creating and Managing Triggers . ..............................................................949

Transaction Management and the Transaction Log . ................................995

Database Snapshots. .................................................................................1043

Database Maintenance. ............................................................................1069

Part V

SQL Server Performance and Optimization

Data Structures, Indexes, and Performance . ...........................................1091

Understanding Query Optimization . ......................................................1209

Query Analysis . ........................................................................................1301

Locking and Performance .........................................................................1341

Database Design and Performance . .........................................................1403

Monitoring SQL Server Performance. ......................................................1427

Managing Workloads with the Resource Governor . ...............................1493

A Performance and Tuning Methodology. ..............................................1519

Chapters on the CD

Part VI

SQL Server Application Develop-

ment

What’s New for Transact-SQL in SQL Server 2008. .................................1551

Transact-SQL Programming Guidelines, Tips, and Tricks . ......................1637

Advanced Stored Procedure Programming and Optimization.................1733

SQL Server and the .NET Framework . .....................................................1787

SQLCLR: Developing SQL Server Objects in .NET . .................................1825

Using XML in SQL Server 2008 . ..............................................................1865

SQL Server Web Services . .........................................................................1927

SQL Server Service Broker . .......................................................................1959

SQL Server Full-Text Search . ....................................................................1997

Part VII

SQL Server Business Intelligence Features

SQL Server 2008 Analysis Services. ..........................................................2029

SQL Server Integration Services . ..............................................................2099

SQL Server 2008 Reporting Services . .......................................................2169

Part VIII

Bonus Chapters

Managing Linked and Remote Servers . ...................................................2243

Configuring, Tuning, and Optimizing SQL Server Options . ..................2273

SQL Server Disaster Recovery Planning. ..................................................2329

2353

Index

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: