Itzik Ben-Gan
sqlperformance.com/author/itzikbengan
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.
Itzik Ben-Gan's Training Days
High Performance T-SQL for the Experienced DB PractitionerSQLBits 2018
Covers performance-centric advanced T-SQL topics.
Mastering T-SQL Querying FundamentalsSQLBits 2017
T-SQL is rooted in logic and mathematics. Mastering it is not trivial. In order to write correct and robust code it is important to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
T-SQL for the Experienced PractitionerSQLBits 2016
This full day seminar covers advanced T-SQL querying and programming topics.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Mastering T-SQL Querying FundamentalsSQLBits 2015
T-SQL is rooted in mathematics. Mastering it can take a lifetime. In order to write correct and robust code the most critical thing is to learn the fundamentals correctly. This seminar provides you with strong foundations to build your knowledge on.
Practical T-SQL - Efficient SolutionsSQLBits 2014
This seminar covers practical use of T-SQL to address common tasks efficiently. It describes in detail powerful uses of features such as window functions, APPLY, MERGE, OFFSET-FETCH, sequences and others.
Itzik Ben-Gan's Sessions
Beware of nondeterministic T-SQL codeSQLBits 2023
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
T-SQL tips and tricks focusing on backdoors and workaroundsSQLBits 2020
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.
Ordering woesSQLBits 2019
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
Window FunctionsSQLBits 2018
This session covers T-SQL Window Functions.
Running TotalsSQLBits 2016
This session covers practical applications of running total computations.
Boost your T-SQL with the APPLY OperatorSQLBits 2015
The session starts with a brief overview of the operator and it
T-SQL Tips and TricksSQLBits 2014
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.
T-SQL Tips and TricksSQLBits 2014
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.
Beware of nondeterministic T-SQL codeSQLBits 2023
Nondeterministic calculations are calculations that when invoked repeatedly, return different results given the same inputs. Most T-SQL developers understand what nondeterministic calculations are, but many aren’t aware of the possible implications of using nondeterministic code. This session will show you the many surprising aspects of using nondeterministic code and will provide best practices that will help you avoid getting into trouble.
T-SQL tips and tricks focusing on backdoors and workaroundsSQLBits 2020
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.
Ordering woesSQLBits 2019
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
Window FunctionsSQLBits 2018
This session covers T-SQL Window Functions.
Boost your T-SQL with the APPLY OperatorSQLBits 2015
The session starts with a brief overview of the operator and it
T-SQL Tips and TricksSQLBits 2014
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.
T-SQL Tips and TricksSQLBits 2014
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.