Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

What’s new for BI in SQL 2016 – Session materials

SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too many to mention, and I saw some interesting sessions. My favorites were David’s session about loading data faster and Catherine’s session about BIML (yes, both are related to SSIS). I… Read more

0 comments, 110 reads

Posted in Koen Verbeeck on 1 October 2015

New SSRS features in SQL 2016 CTP 2.4

SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager at Microsoft because some of the MSDN documentation pages are already updated. One of those pages is What’s New in Reporting Services. There we can see three new features… Read more

0 comments, 825 reads

Posted in Koen Verbeeck on 30 September 2015

Why I hate Pie Charts

The pie chart should be avoided at all costs. Why?

  • you can only display a limited number of slices (although that doesn’t really stop people from creating pie charts with dozens of slices)
  • they take up a lot of space
  • the human brain cannot easily compare slices based on radial…

Read more

0 comments, 139 reads

Posted in Koen Verbeeck on 21 September 2015

Reblog: The Magic Alt Button

SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live action? You can watch my webcast on-demand where I demonstrate this trick. Start watching at around minute 38.

Lately I have been using more and more the awesomeness… Read more

0 comments, 165 reads

Posted in Koen Verbeeck on 17 September 2015

MDS 2016 CTP 2.3: tiles greyed out in Manager

I’m toying around with MDS 2016 CTP 2.3 in preparation of my SQLServerDays session about what is new for BI in SQL Server 2016. I uploaded the sample models into MDS and I opened up Master Data Manager in Internet Explorer to try out some of the new features. The… Read more

0 comments, 134 reads

Posted in Koen Verbeeck on 15 September 2015

The SSDT Evolution

When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects. If you have a full blown Visual Studio installation, you needed the BI templates; if you didn’t have Visual Studio (or the right version), you would… Read more

6 comments, 207 reads

Posted in Koen Verbeeck on 10 September 2015

Webinar – SSIS Best Practices and Tuning Tips

I’ll be giving an SSIS webinar for on Tuesday 15th September 2015.
The title is SQL Server Integration Services Best Practices and Tuning Tips and its abstract goes like this:

Did you ever inherited a slow running un-maintainable mess of an SSIS package? Or do you want to knock…

Read more

2 comments, 1,725 reads

Posted in Koen Verbeeck on 8 September 2015

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 has been released and Report Builder has the following changes:

  • more up-to date look ‘n feel
  • high dpi in the preview
  • HTML5 support

Screenshot of the look ‘n… Read more

0 comments, 240 reads

Posted in Koen Verbeeck on 7 September 2015

SSIS – Unexpected Termination

I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case,… Read more

0 comments, 355 reads

Posted in Koen Verbeeck on 3 September 2015

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 at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post  I received the award last year, so I have a… Read more

0 comments, 145 reads

Posted in Koen Verbeeck on 2 September 2015

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 official SQL Server 2016 page currently still links to CTP 2.2).

There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more

0 comments, 292 reads

Posted in Koen Verbeeck on 1 September 2015

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 file in BIDS/SSDT – which is a 32-bit application – and when you try to run the package, it crashes. This is easily fixed by setting the project property Run64BitRuntime Read more

0 comments, 140 reads

Posted in Koen Verbeeck on 27 August 2015

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 2014 content has been added to some of the exams. Nonetheless, a lot of it is still valid today.

Last week (this is a repost, so not actually last… Read more

2 comments, 312 reads

Posted in Koen Verbeeck on 20 August 2015

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). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of… Read more

0 comments, 1,460 reads

Posted in Koen Verbeeck on 18 August 2015

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 you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the… Read more

0 comments, 151 reads

Posted in Koen Verbeeck on 13 August 2015

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 using Visual Studio 2013 (I explain in this blog post how I set this up using Visual Studio online). However, I got a message saying there was a compatibility issue… Read more

0 comments, 173 reads

Posted in Koen Verbeeck on 11 August 2015

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 I hit OK:

The path to the catalog backup file could not be determined. Integration Services might not be installed on this server, or the user may not have the…

Read more

0 comments, 849 reads

Posted in Koen Verbeeck on 10 August 2015

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. Because I like my code checked in somewhere – you never know if your laptop crashes or even get stolen – I decided to try out Visual Studio Online. It’s… Read more

0 comments, 398 reads

Posted in Koen Verbeeck on 7 August 2015

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 post, there was a forum question about the same issue. I googled and found my own blog post as the answer.

Recently I was developing an SSIS package in… Read more

0 comments, 139 reads

Posted in Koen Verbeeck on 6 August 2015

My favourite books

As I mentioned in the blog post Speaking at SQL Server Days 2015, I’ll be giving a session at the Belgian SQL Server Days. There is a Speaker in the Spotlight section on the site, where a speaker can introduce him/her self by answering a simple survey. One… Read more

2 comments, 173 reads

Posted in Koen Verbeeck on 4 August 2015

Older posts