SQL Clone
SQLServerCentral is supported by Redgate
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.

dataMinds Connect 2017 (win a ticket!)

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m talking about, dataMinds Connect is the new name of the SQL Server Days (the biggest Microsoft Data Platform event in the Benelux). I’ve been a regular speaker at the… Read more

8 comments, 99 reads

Posted in Koen Verbeeck on 18 September 2017

Error Processing Tabular – Method Not Found

Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012, I was greeted with the following error while processing a Tabular model:

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a…

Read more

0 comments, 138 reads

Posted in Koen Verbeeck on 15 September 2017


There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course):

In this… Read more

5 comments, 1,550 reads

Posted in Koen Verbeeck on 6 September 2017

The Wait Is Over – SSIS 2017 Is Here!

Finally, months after the release of SSAS and SSRS projects for VS 2017, we have the ability to create SSIS projects in VS 2017. The title is a bit misleading, because we could already create SSIS 2017 projects using the latest version of SSDT for Visual Studio 2015:

However, if… Read more

11 comments, 278 reads

Posted in Koen Verbeeck on 23 August 2017

Fix for Blurry SSMS in Windows 10

I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a bit blurry on my laptop screen. On another screen, it looked fine though. The cause for this is easy to find in the display settings. My primary screen is scaled… Read more

1 comments, 224 reads

Posted in Koen Verbeeck on 14 August 2017

Two Small Tips for Working with Azure

Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up a project where the data warehouse needed to be fully in the cloud. This was an Azure SQL Database, not Azure Data Warehouse. The size of the DWH was just… Read more

0 comments, 246 reads

Posted in Koen Verbeeck on 10 August 2017

SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server

A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local SSIS catalog. No biggie. However, at the last step of the deployment I was greeted with the following .NET error:

A .NET Framework error occurred during execution user-defined routine or…

Read more

0 comments, 234 reads

Posted in Koen Verbeeck on 8 August 2017

Webinar – Supercharge Your SQL Server Data Warehouse with Columnstore Indexes

I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar will be an introduction to columnstore indexes, which have gained quite some importance since you can now use them in Standard Edition of SQL Server 2016 SP1 or higher.
Title:… Read more

0 comments, 133 reads

Posted in Koen Verbeeck on 7 August 2017

The times they are ae-changing

I have been quite on this blog for a couple of weeks now, and there are a couple of reasons for this. First of all, it’s the holiday season and I need some rest too

Secondly, I have changed jobs since the 1st of August 2017. This means a lot… Read more

0 comments, 186 reads

Posted in Koen Verbeeck on 3 August 2017

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve now finished the remainder of the courses. Now I only need to finish the capstone project. This project only occurs at the start of each quarter and runs for a… Read more

0 comments, 2,314 reads

Posted in Koen Verbeeck on 19 June 2017

Where’s the Trend Line in Power BI Desktop?

A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it is in the analytics pane for certain types of visualization. However, it doesn’t always show up:

(I really resisted the urge to post another “Dude, where is my car” image) Read more

0 comments, 1,462 reads

Posted in Koen Verbeeck on 13 June 2017

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open Online Course), all provided through the edX platform. You are free to participate, but for a verified certificate you will need to pay (and Microsoft/edX has bumped up the… Read more

3 comments, 858 reads

Posted in Koen Verbeeck on 26 May 2017

Power BI Announcements Summary

It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap them up in one single blog post and share my thoughts as well.


Again an amazing release (May 2017). Noticeable features are:

  • Measures on top of live…

Read more

0 comments, 1,025 reads

Posted in Koen Verbeeck on 5 May 2017

Book Review – The Truthful Art

I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about data visualization and we post our thoughts online. A blog post with more detail: Introducing our Data Viz Book Club. The first selected book is The Truthful Art by… Read more

1 comments, 1,061 reads

Posted in Koen Verbeeck on 21 April 2017

PASS BA Marathon – Spring Edition Q&A

The PASS BA Marathon Spring Edition was quite a success. A lot of people tuned in (over 400), the webinar went great (lots of great feedback!) and there were a lot of interesting questions. You can find the recording here. Since I didn’t have the time to answer all… Read more

0 comments, 478 reads

Posted in Koen Verbeeck on 19 April 2017

T-SQL Tuesday 89 – Roundup

I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how it impacts their daily job. The response was overwhelming: we had 30 participants in this months blog party!

Here’s an overview of everyone who participated. Take your time to read… Read more

2 comments, 264 reads

Posted in Koen Verbeeck on 18 April 2017

T-SQL Tuesday #89 – The times they are a-changing

This month’s T-SQL Tuesday is hosted by yours truly! The topic this month: how do you keep up with the fast changing world of data management? Does this impact your job? Or do you feel there’s no impact at all for your position? Do you fear the cloud? And… Read more

2 comments, 1,558 reads

Posted in Koen Verbeeck on 11 April 2017

T-SQL Tuesday #89 Invitation – The times they are a-changing

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic (blog | twitter) and I’m honored to host this month’s… Read more

10 comments, 228 reads

Posted in Koen Verbeeck on 4 April 2017

T-SQL Tuesday #88 – The daily (database-related) WTF

It’s the time of the month again: the T-SQL Tuesday! This month’s edition is hosted by Kennie Nybo Pontoppidan (blog|twitter) and the topic is “daily database related WTF”. In other words, we get to tell one of our horror stories we encountered in our career as… Read more

0 comments, 316 reads

Posted in Koen Verbeeck on 14 March 2017

Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon

I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon is Data Driven Storytelling and Data Discovery. My session will focus on working with Power BI Desktop: getting data in, cleaning it, creating a model and visualizing the data.… Read more

3 comments, 236 reads

Posted in Koen Verbeeck on 6 March 2017

Older posts