Itzik Ben-Gan is a T-SQL trainer and a 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 authored many articles and books including T-SQL Fundamentals and T-SQL Querying. Itzik’s speaking activities include SQLPASS, SQLBits, and other Microsoft Data Platform events. 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.
Itzik Ben-Gan continues his mind-bending series on NULL complexities in T-SQL, treating a variety of constructs including most people's nemesis, the MERGE statement.
Itzik Ben-Gan adds another post to his series on T-SQL pitfalls and best practices, treating complications and limitations of the PIVOT and UNPIVOT operators.
Itzik Ben-Gan describes nested window functions and how they could simplify some tedious query scenarios. He asks for your help voting for these to be included in SQL Server.
Itzik Ben-Gan asks you to invest in SQL Server's future by voting for Row Pattern Recognition, a potential T-SQL syntax extension he deems the next step in the evolution of window functions.
