When working with Azure Data Factory, it's possible you have multiple ADF environments. For example, you can have one for…
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…