SQL Server 2008 Administration in Action cover
welcome to this free extract from
an online version of the Manning book.
to read more

About this Book


It’s getting harder and harder to define the role of a SQL Server DBA. Depending on the organization, a DBA may be involved in a huge number of tasks from data modeling and physical server design through operational tasks such as backup/restore, performance tuning, and security administration. And that’s only scratching the surface; specialist development DBA roles are increasingly common, as are those that specialize in the business intelligence space.

While this book will appeal to a broad range of SQL Server professionals, it’s primarily targeted at the production OLTP DBA whose role includes tasks such as installation, configuration, backup/restore, security, and performance tuning. In order to devote as many pages as possible to these topics, the following areas are not covered:

  • Business intelligence tools: SQL Server Integration Services, Analysis Services, and Reporting Services
  • Development topics: T-SQL programming, locking, and transaction isolation levels
  • Replication and full-text search

How this book is organized

Companion website

Code conventions and downloads

Author Online

About the title