PASS Community Summit 2008: Pre-Conference Seminar

Advanced T-SQL Querying & Programming in Microsoft SQL Server 2005 & 2008

Led by Itzik Ben-Gan
Monday November 17, 2008

Seminar Details

This pre-conference seminar is jam-packed with practical advice for T-SQL querying, programming and tuning. We will cover practical problems T-SQL programmers face daily, providing different solutions for each problem, and explains in detail how to tune your code to produce robust and efficient applications.

Among the subjects that will be covered in this seminar: the OVER clause, islands and gaps, TOP on steroids, custom aggregations, PIVOT on steroids, auxiliary table of numbers, splitting arrays, table-valued parameters, randomization, maintaining sequences, handling hierarchies (with recursive queries, and also within the new HIERARCHYID datatype), dynamic filters, MERGE statement, Grouping Sets, and more.

The seminar covers new features in SQL Server 2008 where relevant.

Seminar Leader Profile: Itzik Ben-Gan

Itzik Ben-Gan is a Mentor and Co-Founder 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 Inside Microsoft SQL Server 2005: T-SQL Querying (MSPress), Inside Microsoft SQL Server 2005: T-SQL Programming (MSPress), and a co-author of Advanced Transact-SQL for SQL Server 2000 (APress). He has written many articles for SQL Server Magazine as well as articles and whitepapers for MSDN. Itzik's speaking activities include Tech Ed, DevWeek, PASS, SQL Server Magazine Connections, various user groups around the world, and Solid Quality Mentors' events to name a few.

Register Now for PASS Community Summit 2008 and this pre-conference seminar!