"Administrators Guide to SQL Server 2005"
eBook Name: Administrators Guide to SQL Server 2005
eBook Type: SQL Server
SQL Server 2000, 2003, 2005
Administrator's Guide to SQL Server 2005 (Microsoft Windows Server System Series)
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 youre a new SQL Server administrator, Buck will help you master core tasks rapidlyand avoid costly mistakes that only show up
when its too late.
If youre familiar with previous versions of SQL Server, hell 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, youll find best practices, real-
world scenarios, and easy-to-use automation scriptsall grounded in Bucks unsurpassed SQL Server knowledge.
Timesaving tips, practical
applications, and start-to-finish examples throughout
Understand the key decision points at every stage of your SQL Server deployment
Perform day-to-day maintenance more efficiently, from hotfixes to backup/recovery
Automate maintenance tasks with the
SQL Server Agent
Establish and audit security on SQL Server 2005 and the underlying Windows Server platform
Monitor
and optimize SQL Server: baselining, profiling, index strategies, query refactoring, and more
Maximize availability using replication, clustering,
mirroring, and SQL Servers new online indexing
Leverage important new improvements in Integration Services and Reporting Services
Use Analysis Services to support enterprise-class Business Intelligence deployments
Even set up a simple configuration of
SQL Server 2005 for freelegally!
Foreword xviii
Chapter 1: Installation and Configuration 1
Chapter 2:
Architecture and Tools 35
Chapter 3: Maintenance and Automation 99
Chapter 4: Security 173
Chapter 5:
Monitoring and Optimization 237
Chapter 6: High Availability 295
Chapter 7: Notification Services and the Service Broker 365
Chapter 8: Integration Services 399
Chapter 9: Reporting Services 451
Chapter 10: Analysis Services 515
Appendix A: Upgrading to SQL Server 2005 581
