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.

Product Details

• Amazon Sales Rank: #132516 in Books
• Published on: 2006-05-17
• Original language: English
• Number of items: 1
• Binding: Paperback
• 544 pages

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

About the Author
The primary author, Itzik Ben-Gan, is a Principal Mentor and Founder of Solid Quality Learning. A SQL Server Microsoft Most Valuable Professional (MVP) since 1999, Itzik has delivered dozens of training events across the U.S. and Europe focused on T-SQL programming, performance tuning and internals, administration, implementation, data warehousing, and online analytical processing (OLAP. An accomplished author, Itzik has written many articles for SQL Server Magazine as well as articles and white papers for MSDN®. Itzik’s speaking activities have included Tech·Ed, DevWeek, PASS, SQL Server Connections, and SQLU Summits, to name a few.

Lubor Kollar is a program manager on the SQL Server team at Microsoft Corporation who focuses on optimization.

Dejan Sarka is a Solid Quality Learning Associate Mentor.

Customer Reviews

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.

Too clever by half
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.

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!