Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. 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 several books including T-SQL Querying (Microsoft Press, 2015) and T-SQL Fundamentals (Microsoft Press, 2012). He has written articles for SQL Server Pro, SolidQ Journal and MSDN. Itzik's speaking activities include TechEd, SQLPASS, IT/Dev Connections, SQLTeach and various user groups around the world. Itzik is the author of SolidQ'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.
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