Microsoft® SQL Server 2005

Part I: Administering SQL Server Components

1 Administering SQL Server 2005 Database Engine . . . . . . . . . . . . . . . . . . . . . . . 11

2 Administering SQL Server 2005 Analysis Services. . . . . . . . . . . . . . . . . . . . . . . 67

3 Administering SQL Server 2005 Reporting Services . . . . . . . . . . . . . . . . . . . . 99

4 Administering SQL Server 2005 Notification Services . . . . . . . . . . . . . . . . 149

5 Administering SQL Server 2005 Integration Services . . . . . . . . . . . . . . . . . 183

6 Administering SQL Server Replication . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209

Part II: Managing SQL Server 2005

7 Conducting a SQL Server 2005 Health Check . . . . . . . . . . . . . . . . . . . . . . . . . . . 261

8 SQL Server 2005 Maintenance Practices. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289

9 Managing and Optimizing SQL Server 2005 Indexes. . . . . . . . . . . . . . . . . . 317

10 Managing Full-Text Catalogs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353

11 Creating Packages and Transferring Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 387

Part III: Securing the SQL Server Implementation

12 Hardening a SQL Server 2005 Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 435

13 Administering SQL Server Security. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 469

14 Encrypting SQL Server Data and Communications . . . . . . . . . . . . . . . . . . . . . 509

Part IV: SQL Server 2005 Overview (located online)

15 SQL Server 2005 Technology Primer. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 537

16 Tools of the Trade . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 571

Part V: Disaster Recovery and High Availability (located online)

17 Backing Up and Restoring the SQL Server 2005 Environment . . . . 597

18 Administering and Managing Failover Clustering . . . . . . . . . . . . . . . . . . . . . . . . 647

19 Administering and Managing Database Mirroring . . . . . . . . . . . . . . . . . . . . . . . 691

20 Administering and Managing Log Shipping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 721

Part VI: Monitoring and Troubleshooting SQL Server (located online)

21 Monitoring SQL Server 2005. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .753

22 Performance Tuning and Troubleshooting SQL Server 2005. . . . . . . . 787

Appendix SQL Server 2005 Management and Administration . . . . . . . . . . . 821