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.

2021 Awards
  

2020 Awards
  

2019 Awards
  

2018 Awards
  

2017 Awards
     

2016 Awards
        

2015 Awards
     

2014 Awards
  

• Analyze Live Data from Snowflake with SSAS and the CData ADO.NET Adaptor (last update: 6/28/2021)
  
• 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)
  

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

• 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)
  

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

• Process Blob Files Automatically using an Azure Function with Blob Trigger (last update: 3/25/2020)
  
• 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 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 Data Factory Pipeline Scheduling, Error Handling and Monitoring - Part 2 (last update: 6/17/2021)
  
• Azure-SSIS Integration Runtime Start-up and Shutdown with Webhooks - Part 2 (last update: 3/4/2019)
  
• Choosing Between SQL Server Integration Services and Azure Data Factory (last update: 1/3/2022)
  
• 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)
  
• Getting Started with Azure Data Factory - Part 1 (last update: 6/3/2021)
  
• 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)
  
• What are Data Flows in Azure Data Factory? (last update: 7/29/2021)
  

• 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)
  
• SSIS Catalog Maintenance in the Azure Cloud (last update: 8/2/2019)
  

• How to Expand a Range of Dates into Rows using a SQL Server Numbers Table (last update: 7/15/2020)
  

• 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)
  

• 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)
  
• Resolve Git Merge Conflict for SSIS Projects (last update: 2/2/2021)
  

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

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

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

• 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)
  

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

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

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

• 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)
  
• Favorite Features of SSIS (last update: 3/1/2021)
  
• 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)
  
• What is an SSIS Package (last update: 4/5/2021)
  
• What is SSIS? (last update: 3/16/2021)
  

• 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)
  

• Execute SSIS Package with SQLCMD and Parameters (last update: 11/24/2020)
  

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

• 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 (last update: 5/27/2014)
  

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

• 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)
  

• 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)
  

• Exploring Snowflake Tasks (last update: 8/9/2021)
  
• Exploring Streams in Snowflake for Change Data Capture (last update: 9/9/2021)
  

• How to Build your First Power BI Dashboard (last update: 12/12/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)
  
• What is Power Query? (last update: 11/15/2021)
  

• How to Create a Pareto Chart in Power BI Desktop (last update: 9/10/2019)
  

• 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)
  

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

• A Day in the Life of a BI Developer (last update: 11/4/2021)
  
• How To Become a Successful BI Developer (last update: 10/18/2021)
  

• 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)
  

• 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)
  

• 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)
  

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

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

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

• 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)
  

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

• 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)
  

• 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)
  

• Top Features in SQL Server Data Tools for Database Projects (last update: 2/23/2021)
  

• How to Create a FOR Loop in SQL Server (last update: 12/13/2021)
  
• How to use @@ROWCOUNT in SQL Server (last update: 7/23/2019)
  
• Learn how to convert data with SQL CAST and SQL CONVERT (last update: 9/16/2021)
  
• Multiple Ways to Concatenate Values Together in SQL Server (last update: 10/5/2021)
  
• SQL INSERT INTO SELECT Examples (last update: 5/20/2021)
  
• SQL SELECT INTO Examples (last update: 1/10/2022)
  
• SQL Server IN vs EXISTS (last update: 4/29/2021)
  
• SQL Server SELECT Examples (last update: 4/12/2021)
  
• SQL Server SUBSTRING Examples (last update: 1/24/2022)
  
• SQL Server T-SQL CASE Statement Examples (last update: 4/20/2021)
  
• SQL UPDATE Statement (last update: 5/5/2021)
  
• T-SQL Tips and Tricks (last update: 2/16/2021)
  
• What are the Aggregate Functions in SQL (last update: 12/3/2021)
  
• What is a SQL Query? (last update: 8/31/2021)
  

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