Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
Beginning Transact-SQL With SQL Server 2000 and 2005 Review by James Counihan
Practical and Usable
The authors have experience both as T-SQL developers and trainers, and it shows. Essential concepts and techniques are explained clearly without talking down to the reader. There's thorough coverage of the most commonly used T-SQL elements, in an easy-to-read style. It's well organized and includes appendices and a good index, making it easy to use as a reference. I work with both SQL Server 2000 and 2005, so it's ideal that the book covers both environments.
There are tons of code samples; most of them use the AdventureWorks database so reproducing them is easy. The exercises at the end of each chapter are good practice - not too difficult, but still good at reinforcing the content (answers are in the back of the book). Parts of my work involve reporting, so I found the chapter on doing Reporting Services development helpful as well. The biggest drawback I've found to this book is that my copy keeps getting borrowed..