AI, Data and Machine Learning

T07 Exploring T-SQL Enhancements: Windowing and More


9:30am - 10:45am

Level: Intermediate

Leonard Lobel



Sleek Technologies, Inc.

This informative and demo-packed session will quickly get you up to speed on SQL Server's powerful windowing features. Learn how to leverage windowing with the OVER clause to calculate running and sliding aggregations, row lookups, and percentiles based on rank. You'll also explore other T-SQL enhancements, including new functions (all 22 of them!), improved error handling with THROW, server-side paging with OFFSET/FETCH NEXT, sequence generators, and metadata discovery techniques. If you want to learn about windowing and other T-SQL enhancements in SQL Server, you won't want to miss out on this session.

You will learn:

  • About windowing features in SQL Server
  • About the 22 new T-SQL functions, including eight new analytic windowing functions
  • About OVER, THROW, OFFSET, and metadata discovery