Itzik-BenGan

This seminar covers advanced aspects of T-SQL querying and programming with a performance-centric focus. The seminar demonstrates practical uses of T-SQL features, with optimized and polished solutions, many of which were developed by the speaker. The seminar also covers the newest additions to T-SQL in SQL Server 2016 and 2017, and some of the planned additions to vNext. The topics covered by the seminar include: the APPLY operator, window functions (including batch-mode processing), adaptive query processing, pivoting and unpivoting techniques, the OFFSET-FETCH filter, system-versioned temporal tables, string splitting and concatenation with the STRING_SPLIT and STRING_AGG functions, SQL Graph, and more.