Microsoft® SQL ServerTM 2005 Administrator's Companion

Front Cover

Get your mission-critical databases up and running quickly with this essential, single-volume guide. This comprehensive administrator’s reference details features and capabilities of SQL Server 2005—including how to implement business intelligence applications. It delivers the easy-to-follow procedures, practical workarounds, and key troubleshooting tactics you need for on-the-job-results.

Discover how to:

  • Perform an installation or upgrade, and configure it on the network
  • Plan and configure the I/O subsystem and model system capacity
  • Create and maintain databases, tables, views, and indexes
  • Administer transactions, deadlocks, and isolation levels
  • Manage users with logins, user IDs, schemas, permissions, and roles
  • Implement failover clustering, log shipping, and database mirroring for high availability
  • Manage and tune snapshot, transactional, and merge replication
  • Administer SQL Server Analysis Services and Reporting Services
  • Monitor, troubleshoot, and fine-tune performance

Includes a CD with a fully searchable eBook.

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

What people are saying - Write a review

We haven't found any reviews in the usual places.

About the author (2009)

Edward Whalen is the founder of Performance Tuning Corporation (, a consulting company specializing in database performance, administration, and backup/recovery solutions. Prior to starting Performance Tuning Corp., Mr. Whalen worked at Compaq Computer Corporation as an OS developer, and then as a database performance engineer. He has extensive experience in database system design and tuning for optimal performance. His career has consisted of hardware, OS, and database development projects for many different companies. Mr. Whalen has written three other books on the Oracle RDBMS and four books on MS SQL Server. He has also worked on numerous benchmarks and performance tuning projects with both Oracle and MS SQL Server. Mr. Whalen is recognized as a leader in database performance tuning and optimization. In addition to his experience in Oracle on many different OS platforms, such as Solaris, AIX, HP-UX, and Windows, he has recently spent significant time working with Oracle on Linux, including the deployment of some of the first RAC clusters on Linux. He works closely with both Red Hat and Novell/SUSE with many different flavors of Linux.

Marcilina Garcia specializes in performance benchmarks, database design, and configuration.

Burzin Patel is a Microsoft program manager focusing on SQL Server application integration and database management.

Stacia Misner is a consultant, educator, mentor, and author focused on business intelligence solutions. She has written or coauthored several BI books, develops custom education services, and is a frequent speaker at SQL Server related events.

Victor Isakov, MCTS, MCITP, is a certified trainer, author, and expert on SQL Server 2005.

Bibliographic information