SQL Server 2000 for Experienced Dbas

by Brian Knight

Written for experienced database administrators, this guide provides a rapid reference to system administration functions. Troubleshooting tips and tricks are included throughout. This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072227885
• ISBN13: 9780072227888
• Release Date: March 2003
• Publisher: McGraw-Hill/Osborne Media
• Length: 520 Pages
• Weight: 1.90 lbs.
• Dimensions: 1.1" x 7.4" x 9.1"

Customer Reviews

Great DBA reference

What a great reference for DBAs who need to support SQL Server. This is one book that was actually fairly easy to read from cover to cover (given the subject matter), but could also be quite easily used as a reference manual.Like all reference books, I was quite pleased to find a really well put together set of appendices. In this final section, the authors discuss system tables (including purpose and schema) as well as undocumented DBCC commands. Perhaps even more useful is a final section on the built-in extended stored procedures available in SQL Server 2000.

Mandatory DBA Knowledge

If you are a DBA then the minimum knowledge that you need is included in this book. All the information in the chapters are necessary. If you were going to an interview and I was your interviewer you would need to aleast be able to answer the questions questions that you can find the answers to in this book. I am a frequenter of the sqlservercentral web site of which Brian is a Co-Founder. It is a great site. I would encourage you to go there and check it out. You can expect to receive the same quality from the site that you can in this book but maybe not the same topics. Great job Brian!

Number one book on my DBA bookshelf.

I'm not too sure what the other reviewers are talking about. This book was excellent! True, it does skip certain sections. In the intro it explained certain sections were skipped because you should already know how to do things like create a database if you're reading this book. It's not a great book for using as a overall SQL Server reference but it's the best SQL Server book on my shelf for day-to-day administration problems that I can't find the answers to in Books Online. I love some of the advanced topics that appear no where in BOL.The clustering and security chapters were my favorite and were farby the most indepth of SQL Injection attacks and clustering attacks that I've ever seen. This book is without a doubt a 5 star book for anyone who has read the rest of the reference books out there and is ready for some more intense info. DBA beginners my not understand some of the topics and think that the author is skipping areas.

little better than the junk out there

I was searching for high availability options while implementing SQL servers. On this subject matter, this book is much better than many of 'mastering', 'unleashing' books which dont even talk about those topics. The writing flow is OK, performance suggestions are better, but, still I feel it is not in-depth for an experienced DBA. I would give a 3.5 for this book. It is a useful book, but not a must-have.

Superb!

This book was filled with great advice to help me in my day-to-day job. It already assumes you know the basics so it may not be the right book for a beginner but once you know the basics, this is your book. The clustering and high availability chapters were especially good with the security one. I've never seen a SQL Server book that's only 500 pages long with this much detailed coverage.