Customer Reviews

Professional SQL Server 2005 Administration (Wrox Professional Guides)

5 star:		(2)
4 star:		(3)
3 star:		(1)
2 star:		(0)
1 star:		(0)

 

 

I am an experienced Sql Server 2000 DBA, and as I get more involved with 2005 the more this book falls short. This is because 2005 is so much more complex than 2000 that a single 700 page book simply does not cover the material. Simple things like schema ownership and management is glossed-over in the book when in fact it is a huge subject. Buy this book as it is useful, but plan on buying the Microsoft books and reading them soon. 2005 marks a major change and you can not afford to be left behind.

Its seems like every time I reach for this book to look up something, a few minutes later I am doing a web search instead.

Maybe its the terrible index. Try looking up something as simple and fundamental as 'views'. No entries.

The book has a really random feel to it. Even if there weren't multiple authors listed on the cover, you could tell. Chapters and even pages feel like they jump from tidbit to tidbit without any real flow.

Summary: decent content with mediocre at best writing

I had been out of SQL 2K for several years and had a project that came up that fit best with a lot of the features of 2005. This book was a good read, lots of good examples, and got me back into the swing of things. The project went well and this book gave me the foundation I needed.

This book is a good reference for DBAs and IT professionals who wants to know everything about SQL Server 2005. I like the structure of contents, the examples and the way it exposes the subjects.

You get a lot for your money with this book. I'm surprised that there are not more reviews.

Great job guys!

SQL Server is a major big-time database. It has numerous features with settings that can dramatically alter its performance. It can also be expanded to handle exceedly large databases with multiple servers handling a great many dips into the database updating, adding, selecting out data. There are also multiple editions of SQL Server to handle clustering, high availability and so on.

This book covers all of these and more. It begins with the architecture, goes on to installation, performance tuning, security, performance tuning, monitoring, indexing, replication, mirroring, backup, logging, and clustering.

The book is intended for people who have some experience with SQL Server, at least to the point of being able to understand what SQL is and how to get data into and out of the database. It will then cover how to tune the queries you're already written to get the maximum performance.

This is a Wrox Professional level book, it is written by professionals for the use of professionals.