Professional SQL Server 2005 Administration (Wrox Professional Guides)

Professional SQL Server 2005 Administration
byBrian Knightet al.
Wrox Press 2007 (768 pages)
ISBN:9780470055205

Drawing on their first-hand experiences to offer best practices, unique tips and tricks, and useful workarounds, the authors of this guide help you handle the most difficult SQL Server 2005 administration issues, including blocking and locking.

Table of Contents
Professional SQL Server 2005 Administration
Introduction
Chapter 1 - SQL Server 2005 Architecture
Chapter 2 - SQL Server 2005 Installation Best Practices
Chapter 3 - Upgrading SQL Server 2005 Best Practices
Chapter 4 - Managing and Troubleshooting the Database Engine
Chapter 5 - Automating SQL Server
Chapter 6 - Integration Services Administration and Performance Tuning
Chapter 7 - Analysis Services Administration and Performance Tuning
Chapter 8 - Administering the Development Features
Chapter 9 - Securing the Database Engine
Chapter 10 - Change Management
Chapter 11 - Configuring the Server for Optimal Performance
Chapter 12 - Optimizing SQL Server 2005
Chapter 13 - Monitoring Your SQL Server
Chapter 14 - Performance Tuning T-SQL
Chapter 15 - Indexing Your Database
Chapter 16 - Replication
Chapter 17 - Database Mirroring
Chapter 18 - Backup and Recovery
Chapter 19 - SQL Server 2005 Log Shipping
Chapter 20 - Clustering SQL Server 2005
Appendix A - Raymond James Lab Report
Index

Категории