Inside Microsoft SQL Server 2005: T-SQL Programming

by Itzik Ben-Gan, Dejan Sarka, Roger Wolter, et al.

Book Overview

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0735621977
• ISBN13: 9780735621978
• Release Date: June 2006
• Publisher: Microsoft Press
• Length: 508 Pages
• Weight: 2.29 lbs.
• Dimensions: 1.3" x 7.4" x 9.0"

Customer Reviews

Excellent book

I've been a SQL Server DBA for each version since 6.5, so with the release of 2005, it was time to make sure that I was up with the new stuff. It's difficult to find a book that has enough technical meat to it without just being a dump of BOL. This book is a winner for me. I really enjoy the pace and depth of the material. For those needing to just refresh their basic knowledge and those that need a good overview of the new features in 2005 (t-SQL related), this is the book for you. It's companion book, t-SQL Querying, make two great additions to anyone's library!

A wonderful gift to the T-SQL world

Having been working on MSSQL for many years, this is definitely the most wonderful book about T-SQL programming that I have read. I was trying to take a glance at the beginning, but quickly slowed down and got immersed in comprehensive reading. It reveals a lot many details, and more importantly, the comparisons, inside T-SQL programming in a very well organized way. It also clears a lot of deeply buried common mistakes, which are often made by even advanced developers. The examples are very accurate and useful to the targeted topics. It's really a book that T-SQL developers should NOT miss. Strongly recommended. Awesome work! Congratulations!

This is an excellent book

This is an excellent book that should be in the library of every serious database developer. It is by far the most detailed book that I have ever read on T-SQL programming. There are many cookbooks or sql recipes books but IMHO this book is many steps ahead of the rest of the books. It is well written, with realistic examples and extremely precise. The one thing that I really loved in this book was that for every problem it provides many alternative solutions and explains the advantages of one solution over the other. Again congratulations to the authors for their great job.

What a book

As someone who has followed Itzik for a while, I expected quite a bit with this book. In every way, shape, manner and form, it delivered. It's very well written. It addresses 'real world' issues and has plenty of examples to support the discussion. It's fairly dry subject material but Itzik keeps it interesting and the more you read, the more you want to read. Having read through it from start to finish, there was no feeling of wanting more. Everything that I wanted to see discussed was (Performance Tuning chapter was utterly superb) and it was discussed to the level I wanted.

Serious SQL Programmers need this book

Firstly, this is not a book for beginners or those new to T-SQL, this is targetted more towards intermediate/advanced programmers. If you're new then look at T-SQL Querying. The level of knowledge and detail that Itzik, Dejan and Roger have and portray in this book is awesome. Do you want to know how SQL Server 2005 internally stores date/time values and what the pitfalls are that you might run into when programming against date/time values (one of the most common problems facing SQL programmers), this book has the answer. With chapters on Stores Procedures, Transactions, temporary tables, views, the service broker and more. Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targetted specifically at SQL Server 2005 and the new ways it handles things, new functions and commands. My only concern and a slight one at that is that with the amount of information the authors are trying to portray in 500 pages, sometimes the reading is heavy. An invaluable book for SQL Server 2005 programmers.