The SSDT Evolution

When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS,...

Webinar – SSIS Best Practices and Tuning Tips

I’ll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015.

The title is SQL Server Integration Services Best...

Report Builder Changes in SQL Server 2016

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

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

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

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...