Customer Reviews

Microsoft SQL Server(TM) 7.0 Administrator's Pocket Consultant (Administrator Pkt Consultant)

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

 

 

First time I saw this book I wasn't sure. I thumbed through it and it looked really good. I went home logged on and searched for Sql books. I bought another book based on reviews. Few weeks ago after getting nowhere with the other book. I bought this book. The rest as they say is history. I am now a firm believer (I've even bought two other books in this series)! If you want to learn Sql server this is the best book. I use it just about every day and it has come to the rescue more than once.

Buy this book you won't be disappointed!

First, this is not a "teach yourself book" it is a reference, geared toward field engineers. With that said, this is a fabulous carry everywhere reference (small; roughly 8"x5"x1" in size) that has just about everything you need to know (from a DBA perspective, that is) for maintaining/installing/etc. SQL Server 7.0. The book is broken into four sections:

I. Administration Fundamentals - Configuring and Tuning

II. Administration - Managing Enterprise, Core DBA, Security

III.Data Administration - Backup/Recovery, Import/Export, Distributed Data/Remote Servers, Replication

IV. Performance, Optimization, and Maintenance - Monitoring/Profiling, Creating Tables/Indexes, DB Automation/Maintenance

Having worked with SQL Server for several years now, I have always dreamed of having a book that summarized (with examples) all aspects of installation and maintenance (and wasn't a 4" thick luggable). Stanek has done it. The contents are well laid out with a very thorough index. Examples are well laid out (step-by-step) to get you through what-ever issue you are working with. The book contains stored procedure calls, but is not a Transact-SQL manual (actually it would be nice if the author would come out with a T-SQL Admin Pocket Guide also!).

I consider this a must-have for every SQL Server DBA's library. It will not gather dust, but instead become VERY dog-eared.

I would say that this is a good addition to a DBA's library. It is small and light yet includes a lot of information. You can read it from cover to cover to get an overview or use it as a reference. It gives an overview and then the syntax and steps for doing each of the major DBA activities. I was able to find some information that I have not found anywhere else, viz., the role of log files for the tempdb database. I would recommend this book.

This book is compact (although pocket means coat pocket in this case) and well-indexed, so it's very handy to have with you if you in a pinch. Unfortunately, much of the book is devoted to explaining where things are in the UI (this button does this, that button does that). There are a few good how-does-this-work sections and lots of tip/best practice/real world insets, but in the final analysis they are only occasionally more helpful to me than the Books Online. Also, as another reviewer mentioned, there is precious little here about the gotchas inherent in certain operations--good SQL and GUI examples of how to accomplish a task, but not much to help you if something goes wrong. In short, if you're asking yourself how much depth there could be in a book whose title advertises that it will fit in your pocket, you should probably buy something else. But there are a lot of topics covered here, and the newer you are to SQL Server 7, the more use this book will be to you.

First book review I've ever written but this book deserves it. As an on the road consultant for a software company, I needed a reference manual that was compact and informational. I am not a DBA and go back and forth between SQL Server and Oracle - master of neither. This book has answered every question I've ever had and is the only reference book I carry (thank you for the small size!). I can't recommend it enough. Probably not deep enough for the true SQL Server DBA's but for every day practical knowledge, can't be beat.

I was home sick and read this book through from cover to cover. This book covers all the basics. I would want to have a total coverage book around as well for reference, but for getting all the basic questions answered, this book does the job. It's hard to find answers to general questions in the heavier reference books due to their total coverage. This book gets to the point and tells you how to accomplish specific and important tasks.

It's also light and small (relatively), so if you're a consultant you can easily carry it along with you. It's very clearly written.

I've bought several sQL server books in the past. This is the ONLY sql book that I actually use. Its a great guide and reference and it has answered every SQL Server question I've ever had (so far). I highly recommend this book.

I don't think you'll find a better book to get you through the day to day admin tasks. The book also covers lots of advanced subjects and it does so extremely well.

The SQL Server Pocket Admin Guide covers the major areas confronting a DBA: Admin, Data Administration, Performnace Monitoring, Backup and Recovery and the like. More importantly it gives clear examples of syntax for things from ISQL and OSQL to creating jobs to run DTS packages.

The one thing it needs to include is an FYI or "gotchas" section. The pocket administrator is not so good at indicating what it is leaving out.

For example: Restoring backups to other dbs with different owners but identical schemas is non-trivial.

DTS packages running stored procedures do not allow for error trapping. This mean if the SP raises an error, the DTS package will not notice and continue as if the SP ran successfully.

While you can not expect a pocket administrator to cover these details. It should briefly indicate that these are issues to be considered, but beyond the scope of the reference.

Other than this oversight, it is an excellent reference.

This book does a good job of covering the major activities confronting a DBA, such as back-ups, recoveries, creating and using DTS packages, scheduling jobs, etc. Furthermore, the book provides concrete syntax or screen shots as part of the step-by-step descriptions. Overall this is a fine addition to a DBA's library. My only complaint is that in some sections, like configuring mail for SQL Server, it uses only MS software for the examples.

For those administrators out there that are responsible for SQL servers, this is a must-have book. Being somewhat partial to MSPress books/manuals, I was especially impressed with the "handi-ness" of this one. Not very heavy on underlying technological details, but a great aid when you're looking for an answer or stored procedure switch.