Top 5 Blog Posts of 2020

4 years ago

If you're wondering what you've all been reading while working at home, here's the list: Cool Stuff in Snowflake –…

Good Riddance 2020

4 years ago

Normally I'd write a "Happy xxxx" blog post at the start of the new year, but this time I'm just…

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…