Publish Database Fails – Script File could not be found

5 years ago

A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the…

Exporting Environment Variables out of the SSIS Catalog

5 years ago

Sometimes when you've created a SSIS catalog, along with folders, environments and environment variables, you want this content on another…

Converting a Datetime to UTC

6 years ago

I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates.…

Optimize for Unknown for Inline Table-Valued Functions

6 years ago

I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and…

Speaking at SQLSaturday Denmark 2020

6 years ago

I'm delighted to announce I'm speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I'll be speaking…

Skip Validation of SSIS Packages

6 years ago

There's been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are…

Speaking at DataMinds Connect 2020

6 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

6 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

6 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

6 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…