Microsoft SQL Server 2008 Management and

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.

Ross Mistry, MVP, MCTS, MCDBA, MCSE Ross Mistry is a seasoned professional in the Silicon Valley and a technology advocate with more than a decade of experience in the computer industry. As a principal consultant and partner with Convergent Computing (CCO), Ross designs and implements SQL Server, Active Directory, and Exchange solutions for Fortune 500 organizations with a global presence. Some of the organizations in which Ross Mistry has taken on the role of lead global Microsoft architect include: Network Appliance, Ross Stores Dress for Less, CIBC, Gilead Sciences, Solectron, The Sharper Image, 2Wire, Infinera, and Wells Fargo’s small business Ecommerce site.

Ross had the opportunity to work with SQL Server 2008 two years prior to the product release. When he is not focused on his SQL Server specialties– high availability, migrations, and security–his attention turns to SQL Server development and Business Intelligence. Ross is an author, co-author, and technical editor of more than 10 books. Many of the books have been bestsellers. Recently, he coauthored Windows Server 2008 Unleashed and SQL Server 2005 Management and Administration. He was a contributing writer on Hyper-V Unleashed, Exchange Server 2007 Unleashed, and SharePoint Server 2007 Unleashed. Ross also took on the role of technical editor for SQL Server 2005 Unleashed and SQL Server 2005: Changing the Paradigm. In addition to being an author and consultant, Ross is a public speaker who conducts seminars on Microsoft topics around the world. He frequently speaks at local SQL Server user groups and international conferences. Most recently, he spoke at the SQL Server PASS Community Summit in North America, SQL Server Europe PASS, SQL Server Connections, and the

Microsoft campuses in San Francisco and the Silicon Valley. As a SQL Server Microsoft Most Valuable Professional (MVP), Ross is heavily involved with the SQL Server community and assists by responding to questions in newsgroups, writing articles for magazines, and blogging for networkworld. com and to IT managers on Microsoft’s TechNet Community Hub site. His blog site is http://www.networkworld.com/community/mistry.

Ross' blog can be viewed at http://www.networkworld.com/community/mistry and he can reached at Ross@cco.com.

Introduction	p. 1
Installing, Administering, and Managing the Database Engine	p. 1
Installing or Upgrading to the SQL Server 2008 Database Engine	p. 11
Whatrsquo;s New for Installation with SQL Server 2008?	p. 12
Deprecated SQL Server 2008 Database Engine Elements	p. 13
Preplanning and Preparing a SQL Server 2008 Server Database Engine Installation	p. 14
Verifying Minimum Hardware Requirements	p. 14
Examining SQL Server 2008 Software Prerequisites	p. 16
Choosing the Appropriate SQL Server Edition	p. 17
Choosing the Appropriate Windows Operating System Version and Edition to Support the SQL Server Installation	p. 18
New Installation, Upgrade, or Transition?	p. 21
Gathering Additional Information Necessary to Proceed	p. 23
New SQL Server 2008 Installation or In-place Upgrade	p. 24
New SQL Server 2008 Stand-alone Installation or Failover Cluster	p. 24
Single-Instance or Multiple-Instance Installation	p. 24
Side-by-Side Installations with Previous Versions of SQL Server	p. 25
Determine Which SQL Server 2008 Features to Install	p. 25
Installing a Clean Version of SQL Server 2008	p. 28
Upgrading the Database Engine to SQL Server 2008	p. 34
Creating a SQL Server Feature Discovery Report	p. 35
Backing Up the Server	p. 35
Verifying System Compatibility	p. 35
Running the SQL Server Upgrade Advisor
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Microsoft SQL Server 2008 Management and Administration

Summary

Author Biography

Table of Contents

Supplemental Materials