Great if you are a DBA
If you work in SQL 2000 and do any administration then you are going to love this book. It does not get in depth as some other books but everything is easy to find and you do not have to search hundreds of pages to figure out what you need to find.
Although I've been working in SQL since 6.5 this book still comes in handy when I need to do something that I haven't done in awhile or need to confirm something.
Good Book
It is a very good book to have for reference. I would definitely recommend this book to anyone who is looking for answers to SQL Server 2000. It gives good detail on configuration and tuning and it also explains how to set up SQL Mail, which I couldn't find in some books I have read. I pretty much use this book every day on the job.
Concise reference manual
This good and concise sqlserver administration reference manual has a complete online version on microsoft.com/technet.
Best for administration
I haven't found a better book for sql admins. This book is extremely informative. I worked for a year with SQL 7 and have been studying and working with SQL Server 2000 for a year and a half. I passed Exam 70-228 in large part due to what I learned from this book. If you are looking for a how-to book that shows just exactly how to accomplish tasks associated with creating and maintaining SQL 2000 this book is for you. This is an excellent book if you want to understand how SQL Server 2000 works as well.
Great Book
A lot of SQL Server books give you the same information included already in Books Online. SQL Server 2000 Administrator's Pocket Consultant is an excellent complement for Books Online, TechNet and MSDN. It covers similar topics, but it digs in where necessary, provides best practices, tips to the internal operations, explaining how SQL Server actually works, with unique information only available in this book.
I always want to know how things work because it helps me to understand the behaviour of a system. In many cases if you don't know how things work it could drive you to some misunderstandings. Here is where SQL Server Pocket Consultant helps out and Stanek has excellent teaching skills.
The book is very compact and full of information. It's all in the details. Chapter 2 "Configuring and Tuning" is a real gem. It helped so much with server and database tuning. Chapter 5 "SQL Server Security" is excellent on the security details. Chapter 7 provides deep detail of DTS and BCP. The final part of the book is the best, in my opinion. It covers performance, maintenance and optimization.
The book's small size makes it easy to take with you where ever you go and its good enough that you'll want to. Overall excellent guide ot sql server.
(16 reviews)
