All-in-One is All You Need. Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference. Get full details on all exam topics including how to: Install and configure SQL Server 2005. Use Transact-SQL. Manage server infrastructure design. Optimize databases. Secure databases and servers. Ensure high availability. Implement backup and recovery strategies. Maximize the built-in administration tools. Use Business Intelligence tools, including SSIS and SSRS. Manage concurrency.