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.

An update on AutoAdjustBufferSize in SSIS 2016

This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible.

Anyway, one of the particular updates that caught… Read more

0 comments, 131 reads

Posted in Koen Verbeeck on 27 July 2016

Overview of Published Articles – 2016Q2

Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:

Read more

0 comments, 147 reads

Posted in Koen Verbeeck on 22 July 2016

Slidedeck ITPROceed – Power BI Status Update

I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power BI @ ITPROceed 2016.

Read more

0 comments, 155 reads

Posted in Koen Verbeeck on 28 June 2016

My first SQL Server 2016 POC

Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of course
One of the first things I noticed, is that installing SQL Server 2016 is quite fast. Installing the database engine, SSIS, SSAS and SSRS is just a matter of… Read more

3 comments, 2,457 reads

Posted in Koen Verbeeck on 9 June 2016

Conditional Formatting and Quick Calcs in Power BI Desktop

There’s a new update out of Power BI Desktop (May 2016), but at the time of writing there’s no official announcement yet.
However, two great new features have been spotted by Chris Webb:

Read more

2 comments, 1,180 reads

Posted in Koen Verbeeck on 31 May 2016

Reblog: Unexpected result with the File System Task

SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default value, so this still applies.

Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File System Task in Integration Services.… Read more

2 comments, 771 reads

Posted in Koen Verbeeck on 24 May 2016

Speaking about Power BI @ ITPROceed 2016

I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this event, it’s an IT Pro focused event in Belgium about Microsoft Technologies. And what’s even better, it’s totally free.

My session will be a general overview of what you… Read more

0 comments, 192 reads

Posted in Koen Verbeeck on 19 May 2016

SSRS and MDX: Think about Cell Properties

I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about… Read more

0 comments, 158 reads

Posted in Koen Verbeeck on 4 May 2016

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, 1,140 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

4 comments, 982 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, 223 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, 201 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, 222 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, 199 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, 206 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, 208 reads

Posted in Koen Verbeeck on 11 March 2016

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com 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, 260 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, 201 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,314 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, 259 reads

Posted in Koen Verbeeck on 3 February 2016

Older posts