Microsoft® SQL Server(TM) 2005 Administrator's Companion

This comprehensive administrator’s reference delivers the details you need to successfully plan, deploy, administer, and support Microsoft SQL Server 2005. The authors—experts in database technologies—provide easy-to-follow procedures, practical workarounds, and key troubleshooting tactics for everyday, on-the-job results. Delve into system features and capabilities—and get hands-on insights for implementing business intelligence applications in organizations of any size. This book covers planning and designing optimal database systems, configuring SQL Server to your I/O system and model system capacity, optimizing for improved performance, and data analysis and reporting. With the ADMINISTRATOR’S COMPANION, you get the in-depth information you need in a single volume. Includes a companion CD.

Edward Whalen is president of Performance Tuning Corporation, where he specializes in database performance, administration, and backup/recovery solutions.

Marcilina Garcia is a senior consultant at Performance Tuning Corporation, where she specializes in database performance benchmarks, SQL Server performance and database design, and system configuration.

Burzin Patel works for Microsoft Corporation specializing in SQL Server 2005 enterprise resource planning application integration and database management.

Stacia Misner is a manager for Hitachi Consulting’s National Business Intelligence practice. Her career spans 20 years as an information technology professional, an educator, and a consultant. She has specialized in the development of business intelligence solutions and delivery of training on business intelligence technologies during the past five years.

Derek Comingore is the software development manager for Hosting.com. He holds MCAD and MCDBA certifications, the Carnegie Mellon Personal Software Process (PSP) credential, and an AAS/BS degree in Computer Information Systems.