Administrator's Guide To SQL Server 2005

DESCRIPTION

This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments.

If you're a new SQL Server administrator, Buck will help you master core tasks rapidly?and avoid costly mistakes that only show up when it's too late. If you're familiar with previous versions of SQL Server, he'll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you'll find best practices, real-world scenarios, and easy-to-use automation scripts?all grounded in Buck's unsurpassed SQL Server knowledge.




TABLE OF CONTENTS
Ch. 1 Installation and configuration 1
Ch. 2 Architecture and tools 35
Ch. 3 Maintenance and automation 99
Ch. 4 Security 173
Ch. 5 Monitoring and optimization 237
Ch. 6 High availability 295
Ch. 7 Notification services and the service broker 365
Ch. 8 Integration services 399
Ch. 9 Reporting services 451
Ch. 10 Analysis services 515
App. A Upgrading to SQL Server 2005 581