Database and Analytics

T14 Exploring T-SQL Enhancements: Windowing and More


1:30pm - 2:45pm

Level: Introductory to 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. We’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!