Inside Microsoft SQL Server 2005: T-SQL Programming - Softcover

Ben-gan, Itzik; Dejan Sarka; Roger Wolter

  • 4.32 out of 5 stars
    47 ratings by Goodreads
 
9780735621978: Inside Microsoft SQL Server 2005: T-SQL Programming

Synopsis

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.

"synopsis" may belong to another edition of this title.

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.

"About this title" may belong to another edition of this title.