Speaking at GroupBy Conference – Spring 2020

5 years ago

I'm excited to announce I'll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I'll be…

Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM

5 years ago

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…

Vote for GroupBy Conference May 2020

5 years ago

GroupBy is a virtual conference, for the community and by the community. Content is focused on the Microsoft Data Platform.…

Switching between different Azure Data Factory environments

5 years ago

When working with Azure Data Factory, it's possible you have multiple ADF environments. For example, you can have one for…

Reading a SharePoint List with Azure Logic App

5 years ago

Sometimes in life you have to do things you really don't like to do. Such as extracting data from a…

Quickly Editing Data in SSMS

5 years ago

WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data.…

SUMX returns incorrect results with duplicates

5 years ago

Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only…

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

5 years ago

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…

Author of the Year 2019 Nomination at MSSQLTips

5 years ago

This year I've been nominated again for the Author of the Year award at MSSQLTips. A lot of other fine…

Cloudbrew 2019 – Slides

5 years ago

Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session…