The PASS Application Development VG serves as a hub of free training and information for application developers working with the Microsoft Data Platform, sharing knowledge and techniques, helping fellow community members avoid trials and tribulations.

News and Updates

Please contact us at appdev@pass.org or via Twitter (@PASSAppDev)  to find out more! 

Missed a webinar you're interested into? Just looking for past recordings? Go to our YouTube Channel and get them: from 2017 and later all webinars for which we have the authorization from the speaker, will also be posted there.

T-SQL Window Functions

Thu, Jul 13 2017 19:00 UTC

RSVP: None

T-SQL Window Functions

T-SQL window functions allow you to perform data analysis calculations like aggregates, ranking, offset and more. When compared with alternative tools to achieve similar tasks like grouping, joining, using subqueries, window functions have several interesting advantages that allow you to solve your tasks often more elegantly and more efficiently. Furthermore, as it turns out, window functions can be used to solve a wide variety of T-SQL querying tasks well beyond their original intended use case, which is data analysis. This session introduces window functions and their evolution from SQL Server 2005 to SQL Server 2017, explains how they get optimized, and shows practical use cases.


Itzik Ben-Gan

Itzik Ben-Gan is a mentor and Co-Founder of SolidQ. 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 is the author of several books including T-SQL Fundamentals Third Edition and T-SQL Querying. Itzik’s speaking activities include SQLPASS, SQLBits, SQL Nexus, SQLU, 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.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids