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.
2020 Awards
2019 Awards
2018 Awards
2017 Awards
2016 Awards
2015 Awards
2014 Awards
2020 Awards

2019 Awards

2018 Awards

2017 Awards


2016 Awards



2015 Awards


2014 Awards

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-Enabled Integration Services Projects in Visual Studio (last update: 4/24/2020)
- 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)
- Customized Setup for the Azure-SSIS Integration Runtime (last update: 11/2/2018)
- Execute SSIS Package in Azure with DTEXEC Utility (last update: 9/15/2020)
- 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)
- Process Blob Files Automatically using an Azure Function with Blob Trigger (last update: 3/25/2020)
- 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)
Azure Data Factory
- Azure Data Factory Multiple File Load Example - Part 2 (last update: 2/3/2020)
- 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)
- Copy Data from and to Snowflake with Azure Data Factory (last update: 8/4/2020)
- 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)
- How To Call Logic App Synchronously From Azure Data Factory (last update: 1/3/2020)
- How to Load Multiple Files in Parallel in Azure Data Factory - Part 1 (last update: 1/23/2020)
- Incremental File Load using Azure Data Factory (last update: 4/3/2020)
- Integrate Azure Function into Azure Data Factory Pipeline (last update: 11/26/2019)
- Migrate a Package Deployment Integration Services Project to Azure (last update: 5/6/2020)
- 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)
- Synchronously Refreshing a Power BI Dataset using Azure Logic Apps (last update: 12/2/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)
Dates
- How to Expand a Range of Dates into Rows using a SQL Server Numbers Table (last update: 7/15/2020)
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)
DevOps
- Branching and Merging Strategy in Git for SSIS Projects (last update: 12/21/2020)
- How to Add SQL Server Integration Services Projects to Azure Devops for Version Control (last update: 7/2/2020)
- How to Resolve Merge Conflicts in Git for SSIS Projects (last update: 1/7/2021)
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)
- How to Execute a PowerShell Script from an SSIS Package (last update: 12/7/2020)
- 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)
- SQL Server Integration Services Power Query Source (last update: 2/19/2020)
- 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 Execute Package Options
- Execute SSIS Package with SQLCMD and Parameters (last update: 11/24/2020)
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 Build your First Power BI Dashboard (last update: 12/12/2019)
- How to Create a Pareto Chart in Power BI Desktop (last update: 9/10/2019)
- Power BI Best Practices (last update: 6/26/2020)
- Power BI Dashboard vs Report vs Workbook (last update: 3/5/2020)
- Power BI Datasets (last update: 9/23/2019)
- Power BI Desktop Data Source Considerations (last update: 5/28/2020)
- Power BI Workbooks (last update: 10/22/2019)
- Refresh Power BI Dataset from Azure Data Factory - Part 1 (last update: 4/22/2019)
PowerShell
- Execute SSIS Package from Catalog with PowerShell - Part 2 (last update: 10/27/2020)
- Execute SSIS Package from PowerShell - Part 1 (last update: 10/9/2020)
- Execute SSIS Package in Cloud and Package Deployment Model with PowerShell - Part 3 (last update: 11/5/2020)
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)
- SSRS Trending Report Example (last update: 9/2/2020)
- 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)
- SQL Server SUBSTRING (last update: 8/13/2020)
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)