Pro SQL Server 2008 Administration

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

• 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

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008.