SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Review of SQL 2000 Fast Answers

By Andy Warren,

The author contacted me a couple weeks ago requesting that his book be put on our review schedule. Mostly I review books that I've decided to read on my own, but this one looked interesting enough to give it a try.

The intro gives a little background on how the book came to be, an outgrowth of pages of notes the author carried around that eventually needed to be organized. I think a lot of us can identify with that. Over time you pick up dozens (if not hundreds) of little tips that you know, but maybe the new developer or junior DBA doesn't know - how do you pass that information on?

The book in organized into 18 chapters covering most everything to do with SQL, within each chapter the format is "How to .....". Lot's of screen shots. I'm all in favor of this, lot easier for me to follow along if I don't have to stop to try to find the same place in Enterprise Manager or wherever to see what the tool looks like at that point in the process. Most of the "how to's" are short and sweet.

I browsed the book pretty thoroughly and was pleased to find a few things. One was a series of how-to's on moving logins and how to fix orphaned logins. Another was a note within a how-to on stored procs indicating that all DDL should be done early in the proc. Another was how to use triggers for auditing, discussing capturing all changes versus just tracking the modified date of the record. Another was how to use the maintenance plan history (rather than job history) to see why a plan failed. The book is also very current, covering the db chaining option included in SP3.

It's a big book, 980 pages. Easy on the eyes. Easy to follow. Runs about $42 right now at Amazon. While I guarantee that everyone will find something in the book they didn't know, I think the real value is that here is a book you can pull out and give someone when they say ask "how do I....?" and they can get what they need in a few pages, not have to read the entire chapter.

The publisher, Curlingstone, is being liquidated, but the author is providing the downloadable files for the book directly from his site.

Total article views: 18209 | Views in the last 30 days: 10
Related Articles

New Author Experience

I was just reading Andy Leonard's blog about being a new author and thought, hey, I need a blog, too...


Data Mining with Microsoft SQL Server 2008 - Sample Chapter

Another sample chapter from Wiley, this time for one of the hot topics in business intelligence: dat...


Defensive Db Programming Chapter 02

This is the review of the second chapter of the book Defensive Database Programming.  The title of t...


High Availability - Sample Chapter

Apress has been generous enough to provide us with a sample chapter from their book on SQL Server 20...


End of October Free Training from PASS Virtual Chapters

This wraps up the last of the free training the PASS Virtual Chapters are providing in October.

backup and restore    
distributed queries    
english query    
performance tuning    
sql server 7    
stored procedures    
user defined function (udf)