Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
- ISBN: 9780672330445 | 067233044X
- Cover: Paperback
- Copyright: 12/23/2008
Realistic, independent, fast-paced, and complete: all the answers DBAs need to successfully manage the new SQL Server 2008 database engine.- Reflects extensive testing in early-adopter enterprise environments, not isolated home labs.- Covers key SQL Server 2008 enhancements: Policy Based Management, Performance Studio, Change Management, Transparent Data Encryption, and more.- Includes best practices, tips, step-by-step configurations, and practical guidance for integrating SQL Server 2008 with other IT infrastructure. This is the most complete, fast-paced, task-based reference for database administrators who need to deploy, manage, and secure Microsoft SQL Server 2008. Authored by a world-class expert on SQL Server in the enterprise, it goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's flagship database. Ross Mistry draws on extensive testing in high-profile production environments to offer step-by-step solutions and never-before-published tips readers won't find anywhere else. Every chapter begins with a section identifying SQL Server 2008's most significant new improvements, and concludes with a convenient summary of best practices. Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, cataloging, and more. He shows DBAs how to harden any SQL Server environment; save time with SQL Server 2008's new policy-based management tools, and secure their data with Transparent Data Encryption (TDE). The book contains extensive coverage of high availability, including major improvements to failover clustering and database mirroring. Mistry concludes with an entire section on monitoring and troubleshooting -- including a full chapter on optimizing application performance with the new Resource Governor.