SQL 2016 CTP 2.3 has been released

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.

You can find the download here (the...

Reblog: Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...

Reblog: How I prepared myself for the MCSE certification

SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...

Nesting Aggregates with Window Functions

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon)....

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

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

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

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

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

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

My favourite books

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