Reblog: Slow source? Make your data flow buffers smaller!

10 years ago

Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If…

Scripts and SSDT-BI 2013

10 years ago

Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means…

SSIS Catalog – Path to backup file could not be determined

10 years ago

I was creating an SSIS catalog at a new project, but I was greeted with the following error message when…

SSDT-BI and Visual Studio Online

10 years ago

Recently I had to create a new business intelligence project at a client. However, there was no source control present.…

Reblog: The OLE DB Source and the Oracle Date Literal

10 years ago

SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original…

My favourite books

10 years ago

As I mentioned in the blog post Speaking at SQL Server Days 2015, I'll be giving a session at the…

Reblog: The shaky bug in SSIS

10 years ago

SQLKover update: I'm reblogging this a bit earlier (it's a quite recent blog post) because I still see people with this…

Reblog: Star Schema The Complete Reference – Review

10 years ago

SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on…

Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

10 years ago

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the…

Speaking at SQL Server Days 2015

10 years ago

I have the great pleasure to announce I'm speaking for the 5th time at the Belgian SQL Server Days! The…