Speaking at DataMinds Connect 2020

4 years ago

I'm delighted to announce I'll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft…

New Management Hub in Azure Data Factory

5 years ago

I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then…

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…