Pro 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


What you'll learn

    * Take advantage of the new administrative features in SQL Server 2008
    * Make intelligent decisions when choosing an installation or upgrade path
    * Define and implement database policies to create a consistent, predictable environment throughout the organization
    * Automate repetitive Tasks for increased productivity
    * Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views
    * Identify and resolve long-running, I/O, and CPU-intensive queries