Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: 18206 | Views in the last 30 days: 10
 
Related Articles
ARTICLE

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...

BLOG

New Author Experience

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

BLOG

Defensive Db Programming Chapter 02

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

ARTICLE

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.

ARTICLE

High Availability - Sample Chapter

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

Tags
administration    
backup / restore    
configuring    
distributed queries    
dts    
english query    
indexing    
installation    
miscellaneous    
monitoring    
openxml    
performance tuning    
replication    
security    
sql server 7    
stored procedures    
triggers    
t-sql    
updategrams    
user defined function (udf)    
xml    
xsl    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones