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.

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

0 comments, 40 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

0 comments, 63 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, 101 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, 85 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, 135 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, 1,991 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, 102 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, 142 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,587 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, 163 reads

Posted in Koen Verbeeck on 24 March 2015

Small presenter tip: changing display mode automatically after presenter view

This morning Adam Machanic (blog | twitter) asked the following question on Twitter:

A very interesting question, as I… Read more

0 comments, 218 reads

Posted in Koen Verbeeck on 4 March 2015

Solving a slow running query issue with UNION

That’s right! I will solve a performance issue by adding a UNION into the query. Interested? Read on!

I recently encountered a curious issue with a query. The query itself wasn’t exactly rocket science: it read data from a few tables and calculated the start and the end dates of… Read more

9 comments, 7,979 reads

Posted in Koen Verbeeck on 25 February 2015

T-SQL Tuesday #63: How do you manage security

This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and its subject is about security.

Security is one of those subjects that most DBAs have to deal with regardless of specialty. So as something we all have to work with at some point or another… Read more

0 comments, 6,178 reads

Posted in Koen Verbeeck on 10 February 2015

Author of the Year at

I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at the website!
I am humbled by the recognition of my fellow peers in the SQL Server community and I’d like to thank all of you, the #sqlfamily, for voting. Read more

2 comments, 138 reads

Posted in Koen Verbeeck on 13 January 2015

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty permission issue I encountered with SSIS. At a new project, someone mentioned me that a scheduled job has been failing for quite some time now (actually since they created the… Read more

2 comments, 175 reads

Posted in Koen Verbeeck on 9 January 2015

Better late than never…

Just like last year, I’m a bit late with the obligatory “how was last year and what is this year supposed to bring” blog post. Anyway, here it is. Let’s start by wishing every one of you the very best for the new year. I hope 2015 may bring… Read more

0 comments, 216 reads

Posted in Koen Verbeeck on 8 January 2015

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.


The third and final part of this series will probably be published this month, so… Read more

0 comments, 207 reads

Posted in Koen Verbeeck on 7 January 2015

Formatting Durations in SSAS: Caveat

I recently published an article on titled Format Durations in SQL Server Analysis Services. For those who haven’t read it I’ll summarize it quickly: it explains how to create an MDX formula that formats durations into an [hh]:mm:ss format, where [hh] can go over 24 hours. For more… Read more

0 comments, 178 reads

Posted in Koen Verbeeck on 22 December 2014

Nominated for the 2014 Tribal Awards

Just like last year, and Simple Talk are hosting the Tribal Awards. In their words:

The Tribal Awards, co-hosted by Simple-Talk and SQLServerCentral, seek to recognize outstanding members of the SQL community. We want to highlight people who are currently leaders due to their writing, speaking, or general community…

Read more

0 comments, 203 reads

Posted in Koen Verbeeck on 18 December 2014

PASS BI VC recording is available now

The recording of the webinar I did for the PASS BI virtual chapter is live!
(Quick reminder: it was the same session as on the SQLServerDays: How to (not) torment your fellow SSIS developer?)

I’m quite pleased with the recording, although I sound like a drunk German scientist sometimes. Read more

0 comments, 335 reads

Posted in Koen Verbeeck on 5 December 2014

Older posts