What will you learn?

This seminar covers advanced T-SQL querying and query tuning topics. We will discuss powerful querying tools such as window functions, APPLY, OFFSET FETCH, and others. Our focus will be on how these tools are optimized and how you can use them to solve common practical T-SQL querying tasks, including gaps and islands, handling intervals, Top N per group, and others. This seminar covers both classic query tuning topics, for example search arguments and join ordering optimization, as well as more recent additions to SQL Server and Azure SQL database, such as row mode versus batch mode processing, batch mode on rowstore, adaptive and intelligent query processing, deferred compilation, scalar UDF inlining, and more.

Visit PASS site


Itzik Ben-Gan is a mentor and Co-Founder of Lucient. A Data Platform 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 T-SQL Fundamentals, T-SQL Querying, and T-SQL Window Functions. Itzik’s speaking activities include PASS Summit, SQLBits, and various user groups around the world. Itzik is the author of Lucient’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.