SQL Server 2005 T-SQL Recipes Book Review

I spend a great deal of time working with SQL Server and find I need at least three solid books associated with SQL Server

  1. A succinct, easy to use, and up-to-date reference guide for SQL Server and T-SQL.

  2. A programmer’s guide to SQL Server that is more in-depth and focuses on developer features.

  3. A solid ADO.NET book.

I have my favorite ADO.NET book, and now I have what I believe is an excellent reference guide to the new features in SQL Server 2005 as well as T-SQL, called SQL Server 2005 T-SQL Recipes by Joseph Sack.

My favorite part of the book is how well it is organized. Within seconds I can find what I need in the table of contents and get to the page that talks about it. This is a crucial feature for a reference book that I have been using a lot and will continue to use as I dig into the new features of SQL Server 2005.

Another of my favorite features is how the book jumps into each recipe immediately without one having to read through a bunch of theory or un-necessary information. This is another must-have feature for a reference book.

If you do want a touch of the big picture, however, the author does a nice job of adding a few pages of background information before diving into a series of recipes on a subject, which is perfect for when you are discovering features for the first time. The “big picture” information doesn’t get in the way when using the book as a reference guide, however, which is giving you the best of both worlds.

Thanks in part to this book, I have learned several cool new features in SQL Server 2005, like: XML Data Type; XQuery, XML Schema Collections, and XML Indexes; Http Endpoints; CLR Stored Procedures, CLR User Defined Functions, etc.

It reinforces things I have already talked about: Ranking Functions like ROW_NUMBER() which is great for record paging as well as best practices like using SCOPE_IDENTITY() as opposed to @@IDENTITY for accessing a newly generated identity value from a database table.

It has really good coverage on performance tuning, indexes, and understanding query execution plans. There is a nice chapter on Service Broker which is next on my list of things to fully understand.  It also discusses a number of subjects like Database Creation, Mirroring, and Backup and Recovery which I kindly ignored for now but as time permits would love to understand a bit better :)

If you are looking for a succinct, easy to use, and up-to-date reference guide for SQL Server 2005 and T-SQL, I highly recommend SQL Server 2005 T-SQL Recipes. You will, however, still need a solid book on ADO.NET and a programmer’s guide to SQL Server 2005, as no author in his/her right mind would try to tackle all of these subjects in one book. No reader would want to haul around such a book either :)

This entry was posted in .NET Book Reviews. Bookmark the permalink. Follow any comments here with the RSS feed for this post.

2 Responses to SQL Server 2005 T-SQL Recipes Book Review

  1. dhayden says:

    Hi Harry,

    I haven’t found a programmer’s guide yet, but Sahil wrote a really good ADO.NET book, called Pro ADO.NET 2.0. You can read the review on my blog at


    and find several posts about it on Sahil’s blog.

  2. Harry says:

    Just curious, what would you recommend for the other 2 books (Programmer Guide and ADO.NET).

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>