Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only…
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight…
This year I've been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine…
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session…
A couple of years back Itzik Ben-Gan (the T-SQL guru) wrote the book Microsoft SQL Server 2012 High-Performance T-SQL Using…
It's T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the…
A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows…
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll…
At a project, we asked if we could get a SQL Server login/user so we could make a connection from…
Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform…