Koen Verbeeck

Koen Verbeeck

SQL Server MVP

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.

2019 Awards
MSSQLTips award

MSSQLTips award

2018 Awards
MSSQLTips award

MSSQLTips award

2017 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

2016 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

MSSQLTips award

2015 Awards
MSSQLTips award

MSSQLTips award

MSSQLTips award

2014 Awards
MSSQLTips award

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)

Azure

Automate the Azure-SSIS Integration Runtime Start-up and Shutdown - Part 1 (last update: 1/18/2019)
Azure Data Factory Pipeline Email Notification – Part 1 (last update: 3/19/2019)
Azure-SSIS Integration Runtime Start-up and Shutdown with Webhooks - Part 2 (last update: 3/4/2019)
Configure an Azure SQL Server Integration Services Integration Runtime (last update: 10/3/2018)
Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime - Part 1 (last update: 12/10/2018)
Connect to On-premises Data in Azure Data Factory with the Self-hosted Integration Runtime - Part 2 (last update: 1/3/2019)
Create an Azure Function to Connect to a Snowflake Database - Part 1 (last update: 10/29/2019)
Create an Azure Function to execute SQL on a Snowflake Database - Part 2 (last update: 11/7/2019)
Customized Setup for the Azure-SSIS Integration Runtime (last update: 11/2/2018)
Executing Integration Services Packages in the Azure-SSIS Integration Runtime (last update: 10/31/2018)
Parallel package execution in Azure-SSIS Runtime (last update: 11/29/2018)
Refresh Power BI Dataset using Azure Logic Apps – Part 2 (last update: 5/2/2019)
Send Notifications from an Azure Data Factory Pipeline – Part 2 (last update: 4/3/2019)
SSIS Catalog Maintenance in the Azure Cloud (last update: 8/2/2019)
Start an Azure Logic App Workflow on Demand or by an Event (last update: 2/12/2019)
Transfer Files from SharePoint To Blob Storage with Azure Logic Apps (last update: 2/5/2019)
Using Files Stored in Azure File Services with Integration Services - Part 1 (last update: 6/7/2019)
Using Files Stored in Azure File Services with SQL Server Integration Services – Part 2 (last update: 7/2/2019)

DBA Best Practices

SQL Server Best Practices for Index Column Order, Money Data Type and DBA Learning Resources (last update: 8/26/2019)
SQL Server Development Best Practices Webcast - Q&A - Part 1 (last update: 8/7/2019)

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 (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

Additional Optimizations for Type 2 Slowly Changing Dimensions in SQL Server Integration Services - Part 3 (last update: 9/3/2018)
Backwards Compatibility in SQL Server Data Tools for Integration Services (last update: 7/31/2018)
Generate multiple SSIS packages using BIML and metadata (last update: 12/10/2013)
Handling Intra-Day Changes for Type 2 Slowly Changing Dimensions in SQL Server Integration Services - Part 4 (last update: 9/19/2018)
Implement a Slowly Changing Type 2 Dimension in SQL Server Integration Services - Part 1 (last update: 8/9/2018)
Implement SFTP File Transfer with SQL Server Integration Services and PSFTP (last update: 10/24/2018)
Introduction to Business Intelligence Markup Language (BIML) for SSIS (last update: 9/12/2018)
Logging Level Recommendations for the SQL Server Integration Services Catalog (last update: 10/15/2019)
More Text Analysis with the SSIS Term Lookup Component (last update: 8/25/2014)
Optimizing Type 2 Slowly Changing Dimensions in Integration Services - Part 2 (last update: 8/17/2018)
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: 10/15/2019)
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 the column causing an error in SQL Server Integration Services (last update: 9/12/2018)

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: 9/12/2018)
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: 9/12/2018)
Retrieve file sizes from the file system using Power Query (last update: 9/9/2015)

Power BI

How to Create a Pareto Chart in Power BI Desktop (last update: 9/10/2019)
Power BI Datasets (last update: 9/23/2019)
Power BI Workbooks (last update: 10/22/2019)
Refresh Power BI Dataset from Azure Data Factory - Part 1 (last update: 4/22/2019)

Professional Development Career

Five Things I Wish I Knew When I Started My Business Intelligence Career (last update: 6/24/2019)

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 Lollipop Chart in SQL Server Reporting Services (last update: 7/5/2018)
How to Create a Slope Chart in SQL Server Reporting Services – Part 1 (last update: 6/1/2018)
How to Create an Index Line Chart in SQL Server Reporting Services (last update: 7/18/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)
How to Create Dumbbell Plots in SQL Server Reporting Services (last update: 6/29/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: 10/15/2019)
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)

Sharepoint

Reading SharePoint Lists with Integration Services 2017 (last update: 7/11/2018)

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 introduced in SQL Server 2016 (last update: 9/12/2018)
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)

T-SQL

How to use @@ROWCOUNT in SQL Server (last update: 7/23/2019)
SQL Server IN vs EXISTS (last update: 5/13/2019)

Temporal Tables

Introduction to SQL Server Temporal Tables (last update: 9/12/2018)
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)

More SQL Server Solutions

download

get free sql tips