Webinar – SSIS Best Practices and Tuning Tips

11 years ago

I'll be giving an SSIS webinar for MSSQLTips.com on Tuesday 15th September 2015. The title is SQL Server Integration Services…

Report Builder Changes in SQL Server 2016

11 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

11 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

11 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

11 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

11 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

11 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

11 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!

11 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

11 years ago

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