Click here to monitor SSC
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.

Dynamic Security in Power BI

In case you haven’t noticed, Power BI added a new feature in preview mode: row level security (RLS). This blog post describes how you  can use this feature to implement dynamic security. In other words, the data being displayed depends on the user that’s viewing it. I will not talk… Read more

3 comments, 73 reads

Posted in Koen Verbeeck on 28 April 2016

Power BI Service error: “This visual has unrecognized fields”

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more

0 comments, 132 reads

Posted in Koen Verbeeck on 22 April 2016

Loading Data into Clustered Columnstore Index with SSIS

I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is between 8 and 9 million rows and I was wondering how I could load data efficiently in this CCI using SSIS.

I stumbled upon this MSDN blog post: SQL Server… Read more

0 comments, 109 reads

Posted in Koen Verbeeck on 21 April 2016

Overview of Published Articles – 2016Q1

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

R Services series:

SSIS & AlwaysEncrypted:

Read more

0 comments, 150 reads

Posted in Koen Verbeeck on 19 April 2016

SSIS Trick: Adding Multiple Packages to a Project

A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing packages to this project. So you can right-click the SSIS Packages node and choose Add Existing Package.

In the dialog, you choose the File System.

All you now… Read more

2 comments, 139 reads

Posted in Koen Verbeeck on 6 April 2016

SQLSaturday Belgium: slidedeck

The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially the one on refreshing data in Power BI was very interesting. There was a nice turnout and the event was well organized. I look forward to the second edition!

You… Read more

0 comments, 162 reads

Posted in Koen Verbeeck on 24 March 2016

Nested Display Folders in SSAS

Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is a fancy term for a live connection to an SSAS cube or model. Anyway, great news, as it drastically improved usability of Power BI Desktop when browsing cubes.

On the… Read more

0 comments, 149 reads

Posted in Koen Verbeeck on 16 March 2016

Reblog: MDS – A Database Error Has Occurred

I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:

515: A database error has occurred. Please contact your system administrator

Too bad I am the system administrator on that machine…

Anyway, after some searching it came… Read more

0 comments, 149 reads

Posted in Koen Verbeeck on 11 March 2016

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its abstract goes like this:

Join us for this webcast to learn about best practices for SSIS, SSRS and SSAS.

Our presenter, Koen Verbeeck has several years of…

Read more

0 comments, 174 reads

Posted in Koen Verbeeck on 24 February 2016

Speaking at the first Belgian SQLSaturday!

I’m delighted to announce that I’ll be giving a session at the very first SQLSaturday (aka SQLSaturday 505) in Belgium. SQLSaturday are free events focusing on SQL Server and related technologies. They are organised around the world. SQLSaturdays are a great opportunity for local speakers to get some real-life experience… Read more

0 comments, 154 reads

Posted in Koen Verbeeck on 15 February 2016

Reblog: SSIS Performance Testing

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in a blog post.

First of all we have to log start and end dates of the package to a table so we can easily calculate the duration a package… Read more

2 comments, 1,251 reads

Posted in Koen Verbeeck on 12 February 2016

The Future of SSMS

One of the smaller announcements amidst the gazillion new features of SQL Server 2016, is that SSMS is now a separate installation. You heard that right (read, probably), no more dragging along those bulky .ISO files with the entire SQL Server set-up just to install some client tools. Just like… Read more

1 comments, 205 reads

Posted in Koen Verbeeck on 3 February 2016

Book Review – Expert Performance Indexing

A few weeks back, the folks at Apress Publishing sent me a copy of the book Expert Performance Indexing in SQL Server for me to review. Since I know both the authors and since I’m familiar with the spectacular work they do, I was happy to do so. Doesn’t mean… Read more

0 comments, 1,591 reads

Posted in Koen Verbeeck on 2 February 2016

Reblog: Building the Script Component

SQLKover update: For some reason, this was my most popular blog post on the old LTD site. Over 110,000 views. People must be building them script components. 

The problem

From time to time I have to script out some logic using a Script Component in a SSIS package. Business as… Read more

0 comments, 184 reads

Posted in Koen Verbeeck on 28 January 2016

Book review – Extending SSIS with .NET Scripting

Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost van Rossum (blog | twitter). My .NET scripting knowledge could use an update, so I decided to read the whole book and provide you with a full… Read more

2 comments, 1,914 reads

Posted in Koen Verbeeck on 21 January 2016

T-SQL Tuesday #74: Be the Change

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

1 comments, 1,038 reads

Posted in Koen Verbeeck on 12 January 2016

Happy Holidays

It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do I plan to do next year?”. I plan on keeping it quite short

2015 was awesome because:

  • I got to speak on ITPROceed and SQLServerDays again, and it was great…

Read more

0 comments, 181 reads

Posted in Koen Verbeeck on 29 December 2015

Performance Tuning with sp_BlitzIndex

Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one of the many free scripts you can get from the great team at Brent Ozar Unlimited.

Recently I went to a client for a one day data warehouse… Read more

3 comments, 2,194 reads

Posted in Koen Verbeeck on 7 December 2015

Master Data Services Configuration Woes

Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re gonna get. Recently I ran into some troubles (or woes) when configuring MDS at a client. The installation went smoothly, as well as the installation of other prerequisites (like… Read more

2 comments, 980 reads

Posted in Koen Verbeeck on 24 November 2015

Older posts