Category: Uncategorized

SQL Window Functions

Links to resources related to Window Functions and my sessions on them.

This page is here to act as an index to material I’ve produced relating to window functions.

GitHub: https://github.com/BarneyLawrence/Sessions-SQL-Window_Functions
My main repository, this holds PowerPoint presentations, sample queries and workbooks either used in sessions, to back them up or to develop the examples used.

Future Sessions

I’ll be presenting on window functions at:
PASS Data Community Summit – November 15th to 18th. Pre recorded session and live QA on Wednesday 15th 04:00 PM–04:30 PM PST

Further Resources

Itzik Ben-Gan’s Blogs at SQLPerformance.com
T-SQL Beyond the Basics – My 2021 PASS Summit session, includes sections on window functions amongst other intermediate techniques.

Hello World

In which new friends are made, jokes are told and the bloggers love of all things cheesy is established.

Hello and welcome to my blog! This is very much a test post to figure out how things work. At some point I will hopefully understand enough of this to make the pages nice and pretty, for now you’ll have to settle for data related blogging and the occasional dad joke.

How do you get Pikachu on a bus?
You have to Poke ’em on!
Here’s some cheese, it was very tasty.