June 2020 QSSUG: Exploring SQL Server Window Functions

Exploring SQL Server Window Functions

Exploring SQL Server Window Functions

Windows Functions first emerged with the 2005 release – and were enhanced in 2012. They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may – at first – seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.

Join us

Presenter: Martin Catherall

About the presenter:

About the presenter:
Martin is a Consultant with SQL Masters Consulting in Brisbane, with close to 20 years of experience on the SQL Server Platform. He volunteers as a PASS Regional Mentor and speaks at many SQL Saturday events around Australia and New Zealand.

Martin started his IT career as a software developer, later becoming a database developer, a DBA and more recently working across the entire Microsoft Data Platform

Location:

Online event (link visible for attendees)

Date & Time:

Wednesday, 3rd June 2020, 5:00PM to 7:00PM AEST.

Register now!

Leave a Reply

Your email address will not be published. Required fields are marked *