Overview

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. Understand how to: Master DBA tips, tricks, and best practices proven in actual enterprise environments Install, upgrade or transition to SQL Server 2008. Harden and Secure an implementation. Encrypt SQL Server from an end-to-end perspective. Implement high availability-and leverage SQL Server 2008's major improvements to failover clustering and database mirroring Save time with SQL Server 2008's new policy-based management tools Performance tune and troubleshoot a SQL Server 2008 environment. Optimize application performance and manage workloads with the powerful new Resource Governor Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more... Bonus Content: The book is based on Windows Server 2008 Step by step instructions of how to implement a failover cluster on Windows Server 2008 SQL Server PoweShell Administration Tasks Consolidate and virtualize SQL Server with Hyper-V Step by step instructions on how to install Hyper-V Proactively Monitor SQL Server with Operations Manager Install Windows Server 2008 certificates to encrypt SQL Server data Contributing Writers include: Hilary Cotter - SQL Server MVP John Welch - SQL Server MVP Marco Shaw - PowerShell MVP Maciej Pilecki - SQL Server MVP Shirmattie Seenarine - Technical Writer

Full Product Details

9780672330445

Table of Contents

Reviews

Author Information

Ross Mistry, MCTS, MCDBA, MCSE - Ross Mistry is a seasoned veteran in the Silicon Valley and has spent more than a decade in the computer industry. As a principal consultant and partner with Convergent Computing, Ross designs and Microsoft implements technology solutions for Fortune 500 organizations with a global presence. Ross specialties in the SQL Server space are migrations, security and high availability, however, he also focuses on Windows Server 2008, Active Directory, Exchange and System Center. Some of his customers include; Gilead Sciences, Network Appliance, Ross Stores, The Sharper Image, bebe Stores, Yahoo, Infinera, William Sonoma, McDonalds, Radio Shack, CIBC and Solectron. Ross has been involved with many bestselling books from SAMS publishing. He is the co-author on Windows Server 2008, principal author on SQL Server 2005 Management and Administration and has contributed to Exchange Server 2007 Unleashed, SharePoint Server 2007 Unleashed, SQL Server 2005 Unleashed and SQL Server 2005 Changing the Paradigm. Ross frequently speaks at international conferences focusing on Microsoft technologies. He has recently spoken at the SQL Server PASS Community Summit in North America, SQL Server PASS Community Summit in Europe and DevConnections . He is also a regular speaker at the Microsoft campus in San Francisco and the Silicon Valley. Ross' blog can be viewed at http://www.networkworld.com/community/mistry and he can reached at Ross@cco.com.

Tab Content 6

Customer Reviews

Recent Reviews

Countries Available