I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC. The topic is about window functions, something that really interests me and that should be in the toolbox of every season SQL developer. The abstract:
The gaps and islands problem is a common problem in data analysis. Some examples are:
In this session, you’ll be introduced to the powerful concepts of window functions in T-SQL. With a practical use case, the gaps and islands problem is explained and solved. At the end of the session, you should feel confident in using window functions in your own data analyses.
A basic understanding of T-SQL querying concepts is required to follow this session.
I hope to see you there!
You can find the slides for my session Building the €100 data warehouse with the…
Disclaimer: this post is not sponsored by Redgate :) For those who've missed it, the…
In the blog post Call a Fabric REST API from Azure Data Factory I explained…
I recently had a new pipeline fail. It was actually a copy of an old…
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data…
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse).…