Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer) (Paperback)

~ Itzik Ben-gan (Author), (Author), Roger Wolter (Author)
Key Phrases: running aggregations, appl userl, first run the following code, Service Broker, Datatype-Related Problems, Visual Basic (more...)

Editorial Reviews

Product Description

This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)—one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You’ll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.

From the Publisher

Key Book Benefits: - Delivers practical, hands-onuidance on sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and much more

- Provides deep background information that helps developers effectively employ cursors and views, and understand how to use Service Broker

- Helps promote mastery of T-SQL

- Features numerous code and table examples, practical advice, logic puzzles, and best practices

See all Editorial Reviews

Product Details

• Paperback: 544 pages
• Publisher: Microsoft Press (June 14, 2006)
• Language: English
• ISBN-10: 0735621977
• ISBN-13: 978-0735621978
• Product Dimensions: 9 x 7.3 x 1.4 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (16 customer reviews)
• Amazon.com Sales Rank: #139,181 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #58 in

  Books > Computers & Internet > Microsoft > Development > SQL Server

Customer Reviews

Most Helpful Customer Reviews

36 of 37 people found the following review helpful:

5.0 out of 5 stars Serious SQL Programmers need this book, June 30, 2006

By	Colin Brown "Colin Brown Microsoft MVP" (Birmingham, Alabama, USA) - See all my reviews (REAL NAME)

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.

11 of 12 people found the following review helpful:

2.0 out of 5 stars Too clever by half, August 6, 2007

By	Dr. Robotnik (Santa Barbara, CA United States) - See all my reviews

Please see review by C. Mialaret. S/he is spot on.

One gets the impression that the author may have been more focused on impressing you with his eruditeness, rather than writing a practical book with useful examples and clear explanations.

Affecianados of Kalen Delaney's 'Inside SQL Server 2000' will be disappointed.

6 of 6 people found the following review helpful:

5.0 out of 5 stars Excellent book, January 3, 2007

By	S. Wallace (Lexington, KY USA) - See all my reviews (REAL NAME)

Amazon Verified Purchase

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!