Brilliant resource
I purchased this guide based on previous recommendations and have to say that this book is extremely well done. I was put off at first by all the times the author said, "we'll cover that in detail later on in chapter number..." It broke the flow a bit, which is why I was tempted to give it only scored 4 instead of 5. However, to be fair, the enormity of what's being covered may be the reason for all the jumping around. Once you get past the first few hundred pages and into the heart of the book, that type of jumping slows down. I've learned so much and have made so many changes to my own SQL configurations as a result, I can't say enough good things about it. It also includes a PDF version on the CD, which is great both for reference and to keep your arms from getting tired holding it. ;-) Very highly recommended.
Very Complete
This book offers very complete coverage of SQL Server 2000. I recommend it to any DBA or SQL Developer who wants a handy all-in-one reference in addition to Books Online. This book includes a PDF version on the CD which is great for portability and I know many IT professionals nowadays aren't willing to buy a book unless an e-copy is included.
Big... but it reads like a novel!
Great book and easy to read! Author explain theory in basic terms and then, he give scripts or examples of how it should work or be written at TSQL level. Index's book it's almost perfect; for being a 1400 pages book it is not difficult to find any topic on it. You will find a lot of nice SQL 2000 tuning tips which add an extra value to the book itself. Could be used as a MCDBA prep. book and of course, in your job or if you're into Databases Admin. and Design business.
The SQL Administration part its my favorite. You will find how to use the GUI for create databases, tables and SQL administration tasks. This part covers almost all GUI and Enterprise Manager options, including backup methods and strategies.
Why not 5 stars?
SQL Internal part tends to be too much technical and difficult to read, IMO. It's Microsoft SQL 2000, i know, a very complex database engine, but more diagrams or explanations don't hurt on this part . If you're a newbie or have not much SQL fundamentals under your belt, you could get boring when you arrive to this. Cluster technology could be better and much more indepth also.
Fantastic book
I was suprised but the book is really good for both beginers as well as experts. I learned a lot from this book even thought I have been working with sql server for a long time.
Would definitely recomend to any level.
The best there is...ok so now i think Sams is better than Wrox...lol
Well I needed a crash course in SQL server management and some T-SQL.I attacked this book head-on. The book is very comprehensive and i am very amazed. It really is a complete guide to the GUI on SQL server. If you want some hard core T-SQL guidance then get another book...in addition. Sams teach yourself t-sql in 21 days is great.
So i am on my way to 70-228 and this awesome book has great chapters on every single knowlege set neccesary to ace this exam.