Professional Microsoft SQL Server 2008 Administration

by Brian Knight, Ketan Patel, Wayne Snyder, Ross LoForte, Steven Wort

Overview

This book is a how-to guide for experienced DBAs.   The book will be loaded with unique tips, tricks and workarounds for handling the most difficult SQL Server admin issues, inlcuding:

• Managing and monitoring SQL Server
  
• Automating administration
  
• Security
  
• Change management
  
• Performance tuning 
  
• Scaling and replication
  
• Clustering
  
• Backup and recovery
  

Overall, the 2008 edition will be about 30ew and revised; however, some key areas of the book will be more heavily updated (as much as  50-60%).

The following new features will be covered in depth in the 2008 book:

• Change Data Capture
  
• Performance Studio
  
• Query Governor
  
• New techniques for Monitoring and Policy Management.
  

The authors also plan to cover related tools that DBAs will find useful---for example, Visual Studio Team Systems for Database Professionals to show DBAs how to perform change management.

The book's companion website will provide all of the sample code in the book, plus useful utilities for automating various administrative tasks.

Product Details

ISBN-13:	9780470440377
Publisher:	Wiley
Publication date:	01/04/2011
Sold by:	JOHN WILEY & SONS
Format:	eBook
Pages:	924
File size:	34 MB
Note:	This product may take a few minutes to download.

About the Author

Brian Knight, SQL Server MVP, MCDBA is a database manager at Fidelity National Financial and a co-founder of SQLServerCentral.com. He has worked with SQL Server for 10 years and has written several SQL Server books, including Wrox' Professional SQL Server 2005 Integration Services.

Ketan Patel is a Development Manager for the Business Intelligence Center of Excellence group at Microsoft. He has worked with SQL Server and other Microsoft technologies for more than 10 years, and has presented at TechEd.

Ross LoForte is a SQL technology architect at the Microsoft Technology Center Chicago who specializes in Microsoft SQL Server solutions. He has more than 16 years experience developing, managing, and architecting SQL solutions on large, mission-critical database platforms. Ross presents at TechEd, SQL PASS, Gartner, TDWI, and other conferences.

Read an Excerpt

Click to read or download

Table of Contents

Forward.

Chapter 1. SQL Server 2005 Architecture.

Chapter 2. SQL Server 2005 Installation Best Practices.

Chapter 3. Upgrading SQL Server 2008 Best Practices.

Chapter 4. Managing and Troubleshooting the Database Engine.

Chapter 5. Automating SQL Server.

Chapter 6. Integration Services Administration and Performance Tuning.

Chapter 7. Analysis Services Administration and Performance Tuning.

Chapter 8. Administering the Development Features.

Chapter 9. Securing the Database Engine.

Chapter 10. Change Management.

Chapter 11. Configuring the Server for Optimal Performance.

Chapter 12. Optimizing SQL Server 2005.

Chapter 13. Monitoring Your SQL Server.

Chapter 14. Performance Tuning T-SQL.

Chapter 15. Indexing Your Database.

Chapter 16. Replication.

Chapter 17. Database Mirroring.

Chapter 18. Backup and Recovery.

Chapter 19. SQL Server 2005 Log Shipping.

Chapter 20. Clustering SQL Server 2005.