Sometimes in life you have to do things you really don't like to do. Such as extracting data from a…
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data.…
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…