I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award…
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3. You can find the download…
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel…
SQLKover update: this was one of the most popular posts on my old blog. It's quite old now and SQL…
Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon).…
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If…
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means…
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when…
Recently I had to create a new business intelligence project at a client. However, there was no source control present.…
SQLKover update: when of the stranger Oracle issues I encountered over the years. Some time after I published the original…