Inside Microsoft SQL Server 2008: T-SQL Programming

by Itzik Ben-Gan, Dejan Sarka, Roger Wolter

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 to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how All the book’s code samples will be available for download from the companion Web site.

Genres: Programming, Technology

640 pages, Paperback

First published April 28, 2009

About the author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions and Microsoft SQL Server 2012 T-SQL Fundamentals. He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.

Itzik Ben-Gan is a co-founder of Solid Quality Mentors, a technical education company, and is a Microsoft SQL Server MVP.

Reviews

[Alexander Fedorenko · Rating 5 out of 5]

forces your​ mind to generate new approaches

[Duc Tran · Rating 5 out of 5]

Inside Microsoft® SQL Server® 2008: T-SQL Programming (2010)

I get this book from my colleague for Spring break 2012 reading. Itzik Ben-Gan and five other authors put together a very powerful learning book for any .NET developer.

This well written book helps readers learn many areas of T-SQL programming like cursors, dynamic SQL, spatial data, tracking access and changes to data, service broker. The areas that I mentioned are rarely found in any MS SQL Server books. Another topic that is very interesting and caught me in surprise is the SQL Injection on Chapter 9 page 362.

I would recommend this book to any developer at all skill levels as:
1. The book covers the most useful and common technical areas for anyone who works with MS SQL Server 2008 in daily basis,
2. The authors explain and give examples for every topics with a simple and straight-forward language.

Over all, I rate this book 5/5 stars.

[Vincent]

I like it.

[Chieko]

Need to read and decide whether to by or not.