Itzik Ben-Gan is a T-SQL trainer, regularly teaching, lecturing and writing on the subject. He has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. He is the author of several books including T-SQL Fundamentals, T-SQL Querying and T-SQL Window Functions. Itzik has been a Microsoft Data Platform MVP (Most Valuable Professional) since 1999.

Sessions

The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.
The session starts with a brief overview of the operator and it
This session covers practical applications of running total computations.
This session covers T-SQL Window Functions.
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
Itzik_Ben-Gan250251.jpg