Microsoft SQL Server 2008 Management and Administration

Microsoft SQL Server 2008 Management and Administration

<p style="margin: 0px;">If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you 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. Each chapter also outlines the benefits of leveraging Windows Server 2008.</p> <p style="margin: 0px;"> </p> <b> <b>Understand how to:</b> </b> <ul> <li> <div style="margin: 0px;">         Master DBA tips, tricks, and best practices proven in actual enterprise environments</div> </li> <li> <div style="margin: 0px;">         Install, upgrade or transition to SQL Server 2008.</div> </li> <li> <div style="margin: 0px;">         Harden and Secure an implementation.</div> </li> <li> <div style="margin: 0px;">         Encrypt SQL Server from an end-to-end perspective.</div> </li> <li> <div style="margin: 0px;">         Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring</div> </li> <li> <div style="margin: 0px;">         Save time with SQL Server 2008’s new policy-based management tools</div> </li> <li> <div style="margin: 0px;">         Performance tune and troubleshoot a SQL Server 2008 environment.</div> </li> <li> <div style="margin: 0px;">         Optimize application performance and manage workloads with the powerful new Resource Governor</div> </li> <li> <div style="margin: 0px;">         Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more…</div> </li> </ul> <b> <b>Bonus Content:</b> </b> <ul> <li> <div style="margin: 0px;">         The book is based on Windows Server 2008</div> </li> <li> <div style="margin: 0px;">         Step by step instructions of how to implement a failover cluster on Windows Server 2008</div> </li> <li> <div style="margin: 0px;">         SQL Server PoweShell Administration Tasks</div> </li> <li> <div style="margin: 0px;">         Consolidate and virtualize SQL Server with Hyper-V</div> </li> <li> <div style="margin: 0px;">         Step by step instructions on how to install Hyper-V</div> </li> <li> <div style="margin: 0px;">         Proactively Monitor SQL Server with Operations Manager</div> </li> <li> <div style="margin: 0px;">         Install Windows Server 2008 certificates to encrypt SQL Server data</div> </li> </ul> <b> <b>Contributing Writers include:</b> </b> <p style="margin: 0px;">Hilary Cotter — SQL Server MVP</p> <p style="margin: 0px;">John Welch — SQL Server MVP</p> <p style="margin: 0px;">Marco Shaw — PowerShell MVP</p> <p style="margin: 0px;">Maciej Pilecki — SQL Server MVP</p> <p style="margin: 0px;">Shirmattie Seenarine — Technical Writer<br> </p>