Inside Microsoft SQL Server 2005 T SQL Programming

Inside Microsoft SQL Server 2005 T SQL Programming
by Itzik Ben-gan, Dejan Sarka, and Roger Wolter

Download Book

If you are the author or the publisher, and would like to link to your site here, please contact us.

About Book

Book 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

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.

Comments

SEND A COMMENT

PLEASE READ: All comments must be approved before appearing in the thread; time and space constraints prevent all comments from appearing. We will only approve comments that are directly related to the article, use appropriate language and are not attacking the comments of others.