Report Builder Changes in SQL Server 2016

10 years ago

As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3…

SSIS – Unexpected Termination

10 years ago

I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages…

Nominated for Author of the Year 2015

10 years ago

I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award…

SQL 2016 CTP 2.3 has been released

10 years ago

A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3. You can find the download…

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

10 years ago

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

10 years ago

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

10 years ago

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!

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…