Koen Verbeeck

Koen Verbeeck is a Business Intelligence professional working at AE. He helps client to get insight in their data and to improve their business intelligence solutions. Koen has 6 years of experience in developing data warehouses, cubes and reports using the Microsoft BI stack. Somehow he has developed a particular love for Integration Services along the way. Koen answers questions at SQLServerCentral.com and occasionally at the MSDN forums, he has a blog at http://www.sqlkover.com and he is a frequent speaker at local SQL Server events.

2017 Awards
MSSQLTips award

2016 Awards
MSSQLTips award

2015 Awards
MSSQLTips award

2014 Awards
MSSQLTips award

Analysis Services Development

Bi-Directional Cross-Filtering in Analysis Services Tabular 2016 - Part 1 (last update: 3/31/2017)
Bi-Directional Cross-Filtering in Analysis Services Tabular 2016 - Part 3 (last update: 4/11/2017)
Bi-Directional Cross-Filtering in Analysis Services Tabular 2016 for Dynamic Row Level Security - Part 2 (last update: 4/5/2017)
Calculating Employee Attrition Rate with DAX – Part 1 (last update: 4/27/2018)
Calculating Employee Attrition with DAX – Part 2 (last update: 5/8/2018)
Creating Ragged Hierarchies in SQL Server Analysis Services (last update: 1/22/2018)
Creating Translations for Analysis Services Tabular 2016 (last update: 7/31/2017)
DAX Enhancements in Analysis Services 2017 (last update: 3/6/2018)
Enhancements for the DAX language in Analysis Services 2016 (last update: 7/20/2017)
Format Durations in SQL Server Analysis Services (last update: 10/27/2014)
How to Define Drillthrough in Analysis Services Tabular 2017 (last update: 2/15/2018)
How To Handle a Parent-Child Relationship in Analysis Services Tabular (last update: 1/9/2018)
How to use the TREATAS function in DAX (last update: 5/22/2018)
Reduce the Size of an Analysis Services Tabular Model – Part 1 (last update: 11/28/2017)
Reduce the Size of an Analysis Services Tabular Model – Part 2 (last update: 12/12/2017)
Scenarios for Using Calculated Tables in Analysis Services Tabular 2016 or Power BI Desktop – Part 1 (last update: 6/14/2017)
Scenarios for Using Calculated Tables in SSAS Tabular 2016 or Power BI Desktop – Part 2 (last update: 6/21/2017)
Setting Display Folders in Analysis Services Tabular 2016 (last update: 10/10/2017)
Using Calculated Tables in Analysis Services Tabular 2016 for Aggregate Tables – Part 3 (last update: 7/4/2017)
Using Visual Studio Configurations in an Analysis Services Tabular 2016 Project (last update: 8/25/2017)
What's New in Analysis Services Tabular 2017 (last update: 3/26/2018)
What's New in SQL Server Analysis Services 2016 – Part 1 (last update: 8/14/2017)
What's New in SQL Server Analysis Services 2016 – Part 2 (last update: 8/16/2017)

Analysis Services Dimensions

Sorting a dimension attribute by another dimension attribute in SQL Server Analysis Services (last update: 6/17/2014)

Analysis Services Performance

Extracting a DAX Query Plan With Analysis Services 2016 Extended Events (last update: 10/3/2017)
How to Use Partitioning in an Analysis Services Tabular model to Improve Processing Performance (last update: 11/13/2017)
Improve Analysis Services Tabular 2017 Processing with Encoding Hints (last update: 10/23/2017)

Analysis Services Security

Object Security in Analysis Services Tabular 2017 (last update: 2/5/2018)

Functions - System

Calculate the Statistical Mode in SQL Server using T-SQL (last update: 3/10/2015)

Indexing

Supercharge your Data Warehouse with Columnstore Indexes - Webinar Q&A (last update: 9/11/2017)

Integration Services Administration

Reporting with the SQL Server Integration Services Catalog (last update: 6/5/2017)

Integration Services Best Practices

Executing, Scheduling and Configuring SSIS packages Webinar Q&A (last update: 5/12/2017)
Integrated Logging with the Integration Services Package Log Providers (last update: 10/29/2015)
SQL Server Integration Services Catalog Best Practices (last update: 4/24/2017)

Integration Services Configuration Options

Setup Environment Variables in SQL Server Integration Services 2016 (last update: 5/29/2017)

Integration Services Connection Managers

SQL Server Integration Services SSIS Transactions without MSDTC (last update: 10/15/2013)

Integration Services Control Flow Transformations

Using Expressions On Precedence Constraints in Integration Services (last update: 9/4/2017)

Integration Services Development

Backwards Compatibility in SQL Server Data Tools for Integration Services (last update: 4/19/2016)
Generate multiple SSIS packages using BIML and metadata (last update: 12/10/2013)
Introduction to Business Intelligence Markup Language (BIML) for SSIS (last update: 11/6/2013)
Logging Level Recommendations for the SQL Server Integration Services Catalog (last update: 4/18/2017)
More Text Analysis with the SSIS Term Lookup Component (last update: 8/25/2014)
Passing SQL Server Agent tokens to an Integration Services package (last update: 3/17/2015)
Simple Text Mining with the SSIS Term Extraction Component (last update: 3/27/2014)
SQL Server Integration Services Best Practices and Tuning Tips Webcast Q&A (last update: 11/4/2015)
Using BIML to Generate an SSIS Import Package (last update: 11/21/2013)
Using hash values in SSIS to determine when to insert or update rows (last update: 2/17/2014)
Using the OData Source in SQL Server Integration Services (last update: 5/7/2014)
Using TOKEN and TOKENCOUNT in SQL Server Integration Services (last update: 2/12/2015)
Using Visual Studio configurations in SQL Server Integration Services projects (last update: 2/17/2015)

Integration Services Error Handling

Continue a Foreach loop after an error in a SQL Server Integration Services package (last update: 4/8/2015)
Retrieve Error Column in SSIS 2016 (last update: 10/23/2015)

Integration Services NULL Management

SQL Server Integration Services REPLACENULL Function (last update: 1/28/2015)

Integration Services Performance

Improve SSIS data flow buffer performance (last update: 4/28/2014)
Improving data flow performance with SSIS AutoAdjustBufferSize property (last update: 3/23/2016)
Semi-blocking Transformations in SQL Server Integration Services SSIS (last update: 5/27/2014)

Integration Services Security

Managing SSIS Security with Database Roles (last update: 1/16/2014)

Master Data Services

Add a Custom Index in Master Data Services 2016 (last update: 4/29/2016)
Approval Workflow in Master Data Services 2016 using Change Sets - Part 2 (last update: 5/27/2016)
Approval Workflow in SQL Server Master Data Services 2016 using Change Sets - Part 1 (last update: 5/17/2016)
Business Rules Extension in Master Data Services 2016 (last update: 2/3/2017)
Create a many-to-many derived hierarchy in SQL Server Master Data Services (last update: 3/2/2017)
How to Merge a Conflict in SQL Server 2016 Master Data Services (last update: 6/3/2016)
How to sync an entity in SQL Server 2016 Master Data Services (last update: 3/31/2016)
How to use Attribute Filters in Master Data Services 2016 (last update: 2/15/2017)
Member Revision History in Master Data Services 2016 - Part 1 (last update: 6/16/2016)
Member Revision History in Master Data Services 2016 - Part 2 (last update: 6/21/2016)
Permission Changes in Master Data Services 2016 (last update: 1/18/2017)
Purge an Entity in Master Data Services 2016 (last update: 12/8/2016)
Purging Entity Members in SQL Server Master Data Services (last update: 6/17/2015)
Using Data Compression in Master Data Services 2016 (last update: 5/6/2016)
Using the Transaction History in SQL Server Master Data Services (last update: 6/9/2015)
What's New for Master Data Services 2016 Webcast Q&A (last update: 12/21/2016)
What's New in Master Data Services MDS 2016 - Part 1 (last update: 3/14/2017)
What's New in Master Data Services MDS 2016 - Part 2 (last update: 3/20/2017)

Microsoft Excel Integration

Extracting a SharePoint List with Power Query (last update: 5/15/2015)
Introduction to Power Query for Excel (last update: 4/28/2015)
Query Folding in Power Query to Improve Performance (last update: 5/22/2015)
Retrieve file sizes from the file system using Power Query (last update: 9/9/2015)

Reporting Services Charts

Add a linear trendline to a graph in SQL Server Reporting Services (last update: 12/30/2014)
Creating a box plot graph in SQL Server Reporting Services (last update: 11/3/2014)
How to Create a Slope Chart in SQL Server Reporting Services – Part 1 (last update: 6/1/2018)
Plotting data on a secondary axis in SQL Server Reporting Services (last update: 1/22/2015)
SQL Server Reporting Services Add Calculated Series to a Graph (last update: 12/15/2014)

Reporting Services Development

How to Create a Slope Chart in SQL Server Reporting Services – Part 2 (last update: 6/20/2018)
What's New for SQL Server Reporting Services 2016 Q&A (last update: 11/29/2016)

Reporting Services KPI

Advanced KPI Configurations in SQL Server Reporting Services 2016 (last update: 10/3/2016)
Create a basic KPI in SQL Server Reporting Services 2016 (last update: 9/21/2016)
Refresh the Data for a KPI in SQL Server Reporting Services 2016 (last update: 10/14/2016)

Reporting Services Overview

What's New in Reporting Services 2016 Service Pack 1 (last update: 12/29/2016)

Reporting Services Parameters

Using a Parameter in a SQL Server Reporting Services 2016 Mobile Report (last update: 1/6/2017)

SQL Server 2016

Create a Treemap Graph in SQL Server Reporting Services 2016 (last update: 9/16/2015)
Customize the SQL Server Reporting Services 2016 Parameter Pane (last update: 11/12/2015)
Exporting SQL Server Reporting Services Reports to PowerPoint (last update: 1/11/2016)
Generate more data for the Wide World Importers sample SQL Server databases (last update: 9/12/2016)
How to create a heat map graph in SQL Server Reporting Services 2016 (last update: 9/21/2015)
How to create a Sunburst Graph in SQL Server Reporting Services 2016 (last update: 9/17/2015)
Install SQL Server 2016 Sample Database: Wide World Importers Data Warehouse (last update: 9/6/2016)
Installing new SQL Server sample databases: WideWorldImporters (last update: 8/15/2016)
Integration Services Logging Levels in SQL Server 2016 (last update: 10/2/2015)
Live Query Statistics in SQL Server 2016 (last update: 8/10/2015)
Reading Always Encrypted Data with SQL Server Integration Services 2016 (last update: 2/22/2016)
SQL Server 2016 Features in CTP2 (last update: 6/30/2015)
SQL Server 2016 R Services: Display R plots in Reporting Services (last update: 2/15/2016)
SQL Server 2016 R Services: Executing R code in Revolution R Enterprise (last update: 1/21/2016)
SQL Server 2016 R Services: Executing R code in SQL Server (last update: 2/1/2016)
SQL Server 2016 R Services: Guide for Client Configuration (last update: 1/4/2016)
SQL Server 2016 R Services: Guide for Server Configuration (last update: 12/15/2015)
SQL Server Integration Services 2016 Control Flow Templates Introduction (last update: 11/30/2015)
SQL Server Integration Services 2016 Incremental Package Deployment (last update: 7/15/2015)
SQL Server Integration Services 2016 Lookups With Always Encrypted Data (last update: 3/8/2016)
T-SQL Enhancements in SQL Server 2016 (last update: 12/9/2015)
What's New for BI in SQL Server 2016 Webcast Q&A (last update: 1/11/2016)
What's New in Integration Services 2016 - Part 2 (last update: 8/10/2016)
What's New in Reporting Services 2016 - Part 2 (last update: 11/11/2016)
What's New in SQL Server Integration Services 2016 - Part 1 (last update: 7/25/2016)
What's New in SQL Server Reporting Services 2016 (last update: 10/25/2016)
Writing Always Encrypted Data with Integration Services 2016 (last update: 3/1/2016)

SQL Server 2017

T-SQL Enhancements in SQL Server 2017 (last update: 4/13/2018)

SQL Server Management Studio

Adding Custom Reports to SQL Server Management Studio (last update: 8/5/2014)
Custom SSMS report to show SQL Server tables per filegroup (last update: 10/3/2014)

Temporal Tables

Introduction to SQL Server 2016 Temporal Tables (last update: 7/28/2015)
SQL Server 2016 T-SQL Syntax to Query Temporal Tables (last update: 8/3/2015)

Upgrades and Migrations

Issues Encountered when Upgrading SQL Server 2012 Service Pack 1 with a Cumulative Update (last update: 12/23/2013)

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Koen Verbeeck

More SQL Server Solutions