Description
Book SynopsisPro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.
- Introduces new administration features of SQL Server 2008
- Shows how to manage a SQL Server 2008 database at professional level
- Provides guidance on performance optimization
Table of Contents
- New Feature Overview
- Pre-Installation Considerations
- Choosing a High Availability Solution
- Installing Microsoft SQL Server 2008
- Upgrading to Microsoft SQL Server 2008
- Post Installation
- Multi-Server Administration
- Managing Security within the Database Engine
- Administering Database Objects
- Indexing for Performance
- Managing Backups
- Restore and Recovery Strategies
- Automating Routine Maintenance
- Monitoring Your Server
- Auditing SQL Server
- Managing Query Performance
- Secrets to Excelling as a Professional DBA
- What's Next?
