Administrator's Guide to SQL Server 2005

by Buck Woody

Book Overview

Loaded with real world examples and time-saving tips, this guide provides comprehensive coverage of installation, configuration, administration, maintenance, security, and troubleshooting. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0321397975
• ISBN13: 9780321397973
• Release Date: January 2006
• Publisher: Addison-Wesley Professional
• Length: 626 Pages
• Weight: 2.05 lbs.
• Dimensions: 1.3" x 7.5" x 9.4"

Customer Reviews

Good Advanced Organizer

First, I'm not a DBA but I install, maintain, and use SQL Server 2005 in lab and workgroup settings. I found this book to work well as an advance organizer and a good source of advice for DBA tasks. I've use the book mainly for topic overviews and guidance on management issues. (I haven't read the reporting and BI chapters -- at least not yet.) I've found the checklists helpful and the script snippets very useful. Scripts, of course, are a great way to capture and document your actions and the book often takes this approach to tasks. Reviewers who mention the content of SQL Server 2005 books are right that the content is likely to be in Books On Line (BOL). However, I bought this book to organize and filter these topics for me. If you can get what you need from BOL as quickly and conveniently as you can with this book then use BOL. I can't, so I bought a copy.

Great SQL Server 2005 Reference

The Administrator's Guide to SQL Server 2005 is a great reference for DBAs and System Administrators planning to implement and maintain SQL Server 2005. While the book is written for Administrators, database developers will benefit from it as well. For example, one of my day to day activities includes testing various SQL Server configurations before they are implemented into production environments that require near 100% uptime. The chapter covering high-availability provided thorough step by step instructions on how to set up database mirroring and replication. I was especially delighted to find instructions on how to create a production-like test environment using virtual machine technology at the end of the chapter. Each chapter is well written and loaded with good practical advice. I highly recommend this book!

Great Resource For the DBA

I bought Buck's other book because I was new to being a DBA, and needed a quick guide. I looked at this one and bought it as well. It has all the features in SQL 2005 that I needed to know, without focusing on programming. I really liked the chapter on the Service Broker, because I heard a few people trying to explain it that just confused me. This one did a great job of laying it out in plain English. He didn't do as well a job on Reporting Services, but he does cover the basics and even shows you how to create a report.