• Überblick

Inside SQL Server 2008: T-SQL Programming

Master the mechanics behind advanced T-SQL programming

Master the mechanics behind advanced T-SQL programming - and deliver more robust solutions

Get a detailed look inside the programming constructs and internals of Transact-SQL (T-SQL)ß- the database programming language built into SQL Server. Guided by T-SQL expert Itzik Ben-Gan and his colleagues inside the Microsoft SQL Server team and beyondß- you´ll gain practical approaches and advanced techniques to optimize your code´s performance.

Discover how to:

• Write T-SQL or CLR user-defined functions, stored procedures, and triggers
• Know when to apply set-based vs. cursor solutions
• Employ new access and change tracking technologies
• Choose the right concurrency model for your solution
• Extend SQL Server with CLR user-defined types (UDTs)
• Implement temporal support; data and time manipulation; and spatial data
• See where and when to use XML and dynamic SQL
• Use Service Broker for reliable, asynchronous processing

About the Authors Itzik Ben-Gan, Dejan Sarka, Roger Wolter, Greg Low, Ed Katibah, and Isaac Kunen:

Itzik Ben-Gan is a mentor and cofounder of Solid Quality Mentors. 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 about T-SQL. He has written many articles for SQL Server Magazine as well as articles and white papers for MSDN. Itzik´s speaking engagements include Tech Ed, DevWeek, PASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors events.

Dejan Sarka focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is a frequent speaker on some of the most important international conferences such as PASS, TechEd, and SqlDevCon. He is also indispensable on regional MS events, for example on the NT Conference, the biggest MS conference in Central and Eastern Europe. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author, coauthor, or guest author of seven books about databases and SQL Server. Dejan Sarka also developed two courses for Solid Quality Learning - Data Modeling Essentials and Data Mining with SQL Server 2008.

Roger Wolter is an architect on the Microsoft IT MDM project team. He has 30 years of experience in various aspects of the computer industry including jobs at Unisys, Infospan, Fourth Shift, and the last 10 years as a Program Manager at Microsoft. His projects at Microsoft include SQLXML, the Soap Toolkit, the SQL Server Service Broker, SQL Server Express, and Master Data Services. He is currently working on a project to master all of Microsoft´s customer and partner data.

Greg Low is a consultant and trainer, best known for his SQL Down Under podcast (www.sqldownunder.com) and for his work as the director of global chapter operations for PASS. Greg is the country lead for Solid Quality Mentors in Australia (www.solidq.com.au), a SQL Server MVP, and a Microsoft Regional Director. He holds a PhD in computer science from QUT and has written a number of books on SQL Server and on building technical communities. For Microsoft, he has written SQL Server white papers and training materials and is one of a handful of trainers chosen to deliver the Microsoft Certified Masters program for SQL Server 2008.

Ed Katibah is a program manager on the Microsoft SQL Server Strategy, Infrastructure and Architecture team. Ed began his professional career over 34 years ago while working in a University of California, Berkeley, research group at the Space Sciences Laboratory. Ed has extensive experience in the spatial industry with jobs ranging from research, software development, consulting, application programming, and large-scale spatial database production systems. Since 1996, Ed has worked exclusively on spatially enabled database systems for Informix, IBM, and now Microsoft.

Isaac Kunen is a program manager on the SQL Server engine programmability team. Since joining Microsoft in 2005, he has worked on the type system, SQL CLR integration, and database extensibility. His most prominent project to date is the spatial data support in SQL Server 2008. Isaac is currently focusing on reducing the complexity of database application development, deployment, and management.