Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: window functions

mssqltips wide

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

October 31, 2024October 31, 2024 Koen Verbeeck Leave a comment

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: […]

Read More

Nesting Aggregates with Window Functions

August 18, 2015September 10, 2020 Koen Verbeeck Leave a comment

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of items per folder. An example: […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements
  • How I passed the DP-700 Exam

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (112)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress