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.

Reblog: Star Schema The Complete Reference – Review

SQLKover update: 1.5 year later, I still stand by my position: Star Schema The Complete Reference is the best book on dimensional modelling around. Recommended/obligatory reading!

I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph Kimball’s Data Warehouse Toolkit,… Read more

0 comments, 103 reads

Posted in Koen Verbeeck on 23 July 2015

Reblog: Creating a Semi-additive Measure over a Parent-child Hierarchy

Originally this blog post would be titled “Disabling aggregations over a parent-child hierarchy”, but I thought it could create confusion with the Aggregation Design concept in Analysis Services (SSAS), which is something completely different.

What I want to describe in this blog post is a method forcing a parent-child… Read more

0 comments, 99 reads

Posted in Koen Verbeeck on 16 July 2015

Speaking at SQL Server Days 2015

I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The SQL Server Days is the largest SQL Server conference in the Benelux (and maybe beyond :)) and is hosted by It will be great to see the #sqlfamily… Read more

0 comments, 107 reads

Posted in Koen Verbeeck on 15 July 2015

Power BI Confusion

Just a quick post on some Power BI material that I believe should reach as many people as possible. I get the notion there is a lot of confusion about what is possible in Power BI v2 and which features are supported in the free and in the paying version.… Read more

2 comments, 220 reads

Posted in Koen Verbeeck on 14 July 2015

T-SQL Tuesday #68: Just say No to Defaults

It’s the second tuesday of the month and you know what that means! T-SQL Tuesday time! If you don’t know what it means, T-SQL Tuesday is a monthly blog party of the SQL Server community – started by Adam Machanic (blog|twitter) – where everyone is invited… Read more

0 comments, 1,666 reads

Posted in Koen Verbeeck on 13 July 2015

Thoughts on Power Query and SSIS

Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):

His question was a response on my earlier blog post What’s the deal with Excel and SSIS?, where I remarked that Power Query… Read more

2 comments, 189 reads

Posted in Koen Verbeeck on 13 July 2015

Reblog: What’s the deal with Excel and SSIS?

SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to the rescue!

When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest,… Read more

3 comments, 156 reads

Posted in Koen Verbeeck on 10 July 2015

100th post

This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)

I started blogging at the end of 2012, almost 3 years ago and it has been an amazing ride so far. I’ve apparently gathered almost 1.5 million views (I don’t really trust that figure… Read more

2 comments, 110 reads

Posted in Koen Verbeeck on 10 July 2015

Overview of Published Articles – 2015Q2

Here is an overview of the articles I published in the secondt quarter of 2015.



I’ve been busy writing tips!

Read more

0 comments, 135 reads

Posted in Koen Verbeeck on 9 July 2015

Hello world!

Hi there!

Although this looks like my first blog post, it actually isn’t. This is the new place for my blog, because I have already been blogging for almost 3 years at the site LessthanDot. I gathered 100 blog posts about business intelligence, SQL Server, Integration Services and other… Read more

3 comments, 93 reads

Posted in Koen Verbeeck on 8 July 2015

How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned tables. We’ll see what catches on. In a gist, such a table keeps track of the history of its rows by the use… Read more

2 comments, 195 reads

Posted in Koen Verbeeck on 3 July 2015

Doing a Full Outer Join in Power Query

A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities of  the Microsoft BI platform is demonstrated alongside client testimonials. I gave a session called “Drilling across Analysis Services cubes using Power Query”, which talked about how you can use… Read more

1 comments, 1,085 reads

Posted in Koen Verbeeck on 2 July 2015

SQL Server 2016 CTP 2.1 has been released

Microsoft is all about rapid release cycles nowadays. We already experienced this with Power BI, where monthly new features and improvements have been added.
Now SQL Server appears to get the same treatment: SQL Server 2016 CTP 2.1 has just been released. There is nothing groundbreaking in this release… Read more

0 comments, 153 reads

Posted in Koen Verbeeck on 29 June 2015

My first SQL 2016 bug

A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent hours creating a VM because there were hundreds of Windows updates).
It seems I have already found a very small bug while creating a new database:

Apparently they forgot… Read more

0 comments, 125 reads

Posted in Koen Verbeeck on 29 June 2015

Demystifying Power BI – slidedeck

ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the other speakers!

My session went pretty well, at least from my point of view, although I had to rush my demos a bit since there was only a 50 minute… Read more

0 comments, 159 reads

Posted in Koen Verbeeck on 16 June 2015

SQL 2016 Preview has been released!

For those who haven’t noticed already:

SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means it is play time!

You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the… Read more

6 comments, 2,047 reads

Posted in Koen Verbeeck on 28 May 2015

Speaking at ITPROceed 2015

This year I have the opportunity again to speak at ITPROceed, the biggest (Microsoft-related) conference in Belgium for the IT professional. The conference takes place the 11th of June at Utopolis Mechelen. My session is situated in the Data Platform & Internet of Things track and is titled Demystifying… Read more

0 comments, 120 reads

Posted in Koen Verbeeck on 27 May 2015

Overview of Published Articles – 2015Q1

Here is an overview of the articles I published in the first quarter of 2015.


This will probably be my last article for Intense School for a while.


But on the other hand, I’ve doubled my efforts for… Read more

0 comments, 152 reads

Posted in Koen Verbeeck on 22 April 2015

Overview of the data visualization books by Stephen Few

I recently finished the book Now You See It: Simple Visualization Techniques for Quantitative Analysis by Stephen Few of Perceptual Edge. Stephen Few is a data visualization guru and his books about designed visualizations has changed my career in BI and how I develop reports and dashboards. Few currently… Read more

5 comments, 5,695 reads

Posted in Koen Verbeeck on 7 April 2015

The shaky bug in SSIS

You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A… Read more

0 comments, 177 reads

Posted in Koen Verbeeck on 24 March 2015

Older posts