Speaking at SQLSaturday Vienna 2021

4 years ago

I'm thrilled to announce I've been selected to speak at SQLSaturday Vienna. Actually, it's on Friday 15th of January, so…

Migrating SSIS to Azure – an Overview

4 years ago

For quite some time now, there's been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There,…

Publish Database Fails – Script File could not be found

4 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

4 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

4 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

4 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

4 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

4 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

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

4 years ago

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