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…
GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform.…
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…