I am Joost van Rossum, a Microsoft Business Intelligence consultant at ilionx. On this joint Microsoft SQL Server and Business Intelligence blog I post especially on all the new Azure BI stuff. On my own blog I post about SSIS and related stuff like TSQL, BIML and PowerShell. Besides my work at ilionx I am part of SQL PASS Netherlands that organizes knowledge events about the Microsoft Data Platform, such as SQL Saturday. In 2014 Microsoft awarded me with a MVP award for Microsoft Data Platform. |
My contributions:
- Synapse snack: mount storage container in notebook (2024-12-07)
- Synapse - Run all notebooks in a foreach loop (2024-09-22)
- Synapse - ReferenceError: Response is not defined (2024-09-21)
- Toggle Azure Synapse Triggers during deployment (2024-01-01)
- Give Power BI access to Synapse Serverless SQL Pool (2023-12-26)
- Deploying Synapse Serverless SQL pool with DevOps (2023-12-24)
- Synapse and ADF Pipeline snack - Disable Activity (2023-06-28)
- Synapse - Automatically check naming conventions (2023-05-05)
- DevOps - Build Validation to check branches (2023-04-28)
- Synapse snack - Increment counter variable (2023-04-05)
- Synapse - Cleanup workspace after deployment (2023-04-01)
- Synapse - Change Data Feed (CDF) on delta tables (2023-03-26)
- DevOps - Get-SpnAccessToken is obsolete (2023-03-22)
- Synapse - Creating Silver Delta Tables (2023-03-20)
- Synapse - Using Spark SQL to time travel Delta Tables (2023-03-19)
- Synapse - Add existing Delta Table to Lake Database (2023-03-19)
- Synapse snack - Get child pipeline value to parent (2023-03-05)
- Streaming data Azure & Power BI - Streaming dataset (2023-02-23)
- Streaming data Azure & Power BI - Stream Analytics (2023-02-19)
- Show dataset parameters in Azure Synapse Dataflow (2023-02-13)
- Streaming data Azure & Power BI - Event Hubs (2023-02-06)
- Streaming data Azure & Power BI - Introduction (2023-02-05)
- Deploy a Power BI dataset via a DevOps - Publish (2023-01-27)
- Deploy a Power BI dataset via a DevOps - Build (2023-01-26)
- Deploy a Power BI dataset via a DevOps - Setup (2023-01-26)
- Cleanup Synapse before deployment (2022-12-31)
- Deploy Azure SQL Databases via a DevOps pipeline (2022-11-12)
- Create Data Lake containers and folders via DevOps (2022-11-07)
- Deploy Synapse workspaces via DevOps - Pipeline (2022-10-03)
- Deploy Synapse workspaces via DevOps - Setup (2022-10-03)
- Synapse - error: missing required argument 'factoryId' (2022-10-02)
- Synapse - 'node' is not recognized as an command (2022-09-30)
- Sending test messages to Azure Event Hubs (2022-09-13)
- DevOps snack: If condition in YAML code (2022-08-31)
- Skipped dependency between pipeline activities (2022-07-31)
- Break or stop ForEach loop in ADF and Synapse (2022-06-08)
- ADF Snack: Trigger every hour during office hours (2022-06-02)
- Refresh single table in PBI Dataset from within ETL (2022-05-19)
- DevOps: SQL Server - NETFramework v4.5 not found (2022-05-13)
- Refresh Power BI Datasets via its name instead of Id (2022-05-08)
- Refresh Power BI Datasets with ADF or Synapse (MSI) (2022-04-30)
- Refresh Power BI Datasets with ADF or Synapse (SP) (2022-03-21)
- ADF Snack - Script Activity (2022-03-14)
- ADF Snack - Give ADF access to SQL DB via MSI (2022-02-20)
- ADF Snack - Empty file when creating new folder (2022-02-13)
- ADF Snack - Give ADF access to Data Lake via MSI (2022-02-12)
- Release Power BI via Azure DevOps extension (2022-01-31)
- Delta Lake support in Azure Synapse Analytics (2021-12-05)
- ADF: Looping through pipelines and execute them (2021-12-01)
- Synapse pipeline pass parameter to notebook (2021-11-27)
- ADF Release - Use script to enable certain Triggers (2021-11-18)
- ADF Release - Update Linked Service while deploying (2021-11-14)
- ADF Release - Set global params during deployment (2021-11-04)
- ADF Release - Create YAML CICD Pipeline - part 2 (2021-11-01)
- ADF Build - Create YAML CICD Pipeline - part 1 (2021-10-31)
- ADF Snack - Fail pipeline on purpose (2021-10-15)
- DevOps Snack: Get Treeview of files on agent (2021-09-20)
- ADF Build - missing publish_config.json (2021-09-19)
- ADF Build - missing arm-template-parameters-definition.json (2021-09-18)
- ADF Release - ResourceGroupNotFound (2021-09-17)
- Virtual Network Data Gateway for Power BI (2021-09-03)
- Analyze Azure Data Factory logs - part 3: Power BI (2021-08-31)
- Analyze Azure Data Factory logs - part 2: queries (2021-07-05)
- SQL Snack: Create readonly DB user in Azure SQL DB (2021-07-05)
- Analyze Azure Data Factory logs - part 1: setup (2021-06-06)
- Power Apps Snack: Add an Attachments control (2021-05-31)
- ADF Snack - hide activity input and output from log (2021-04-02)
- dataMinds Saturday - REST APIs in Data Factory (2021-03-06)
- Pausing/resuming Dedicated SQL Pools from Synapse (2021-03-01)
- DevOps Snack: Change PowerShell version in YAML (2021-02-27)
- Scaling Azure Analysis Services with ADF only (2021-02-13)
- DevOps Snack: Keyboard Shortcuts YAML editor (2021-02-12)
- Scaling Azure Dedicated SQL Pools from ADF (2021-01-11)
- Pausing and resuming Dedicated SQL Pools from ADF (2021-01-06)
- Power Apps Snack: Don't repeat yourself (again) (2021-01-04)
- ADF Snack: get files of last hour (2020-12-29)
- ADF Snack: use stored procedure output (2020-12-27)
- Process Analysis Service with Firewall in ADF only (2020-11-14)
- ADF Snack: Adding metadata columns (2020-11-01)
- Synapse snack: No new Azure SQL Database allowed (2020-10-15)
- Execute pipelines from an other Data Factory Sync (2020-10-13)
- Snack: Create Azure Automation Runbook (2020-10-10)
- Pause all/an Azure Synapse SQL Pool(s) (Az) (2020-10-02)
- Using global parameters in Azure Data Factory (2020-09-24)
- Execute pipelines from an other Data Factory Async (2020-08-31)
- Pause and Resume Analysis Services with ADF only (2020-06-14)
- Process Analysis Service with Data Factory only (2020-06-13)
- Create and deploy a C# Azure Function (2020-06-09)
- Create and deploy a Python Azure Function (2020-05-23)
- Setup Visual Studio code for Azure Functions (2020-05-21)
- Use Managed Service Identity for Synapse PolyBase (2020-05-03)
- Azure Data Factory - Use Key Vault Secret in pipeline (2020-05-01)
- Azure Data Factory - Parameters event based triggers (2020-04-30)
- Power Apps Snack: Don't repeat yourself (2020-04-24)
- Embed a Power BI tile in Power Apps with filters (2020-03-21)
- Power Apps Snack: Loop through combobox items (2020-03-19)
- Power Apps: Get next item from gallery (2020-03-12)
- Use Azure Key Vault for Azure Databricks (2020-02-20)
- Use Azure Key Vault for Azure Data Factory (2020-02-16)
- Schedule Up/Downscale Azure SQL Database (API) (2020-02-02)
- Schedule Up/Downscale Azure SQL Database (TSQL) (2020-02-01)
- Schedule Up/Downscale Azure SQL Database (Az) (2020-01-31)
- Azure snack: prevent accidental deletes (with locks) (2020-01-18)
- Schedule start and stop of Azure Virtual Machine (Az) (2020-01-05)
- Schedule start & stop of Azure Analysis Services (Az) (2019-12-31)
- SendGrid - Send emails via a Runbook (2019-12-09)
- Azure Data Factory Webhook activity calls Runbook (2019-12-08)
- Use Azure Key Vault for Automation Runbooks (2019-12-05)
- SendGrid - Sending emails via ADF & LogicApps (2019-12-01)
- Archiving within a Blob Storage container (2019-11-26)
- Runbook snack: read parameters from Data Factory (2019-11-18)
- Runbook snack: Using the Azure Run As Connection (2019-11-17)
- Databases in DevOps - Build Pipeline (2019-10-31)
- Flow Snack: Refresh Power BI (2019-10-21)
- Databases in DevOps - Pre-Deployment scripts (2019-09-12)
- Databases in DevOps - Introduction (2019-08-31)
- Staging with the Azure Data Factory Foreach Loop (2019-06-05)
- Azure - Reuse Power BI dataflows (2019-03-29)
- Power Apps Snack: Refresh Power BI (automatically) (2019-03-23)
- ADF snack: Pipeline templates (2019-02-18)
- Introducing Azure Function Activity to Data Factory (2019-01-31)
- Power BI - Introducing dataflows (2018-12-31)
- Power Apps: Add Microsoft Flow to delete records (2018-11-12)
- Power Apps Snack: RemoveIf not deleting all records (2018-10-31)
- SSRS Snack: Download all SSRS reports (2018-09-29)
- Power Apps Snack: Pass values to other screen (2018-08-31)
- Power Apps Snack: Replace Textbox by Drop down (2018-07-08)
- Snack: Executing SSIS packages in Azure Logic App (2018-05-31)
- Runbook with ADF: Method not found (2018-04-27)
- Add email notification in Azure Data Factory V2 (2018-03-01)
- AAS Snack: process Azure Analysis Services with SSIS (2018-02-23)
- Cognitive functions U-SQL: text sentiment (2018-02-14)
- Pause everything on your Azure playground - Tags (2018-01-01)
- Pause everything on your Azure playground (2017-12-30)
- Cognitive functions U-SQL: emotion, age & gender (2017-11-16)
- Cognitive functions U-SQL: image tagging (2017-11-16)
- Use PolyBase to read Data Lake in Azure SQL DW (2017-10-23)
- Schedule Process Azure Analysis Services database (2017-10-11)
- Use PolyBase to read Blob Storage in Azure SQL DW (2017-08-20)
- Azure SQL Database vs Azure SQL Data Warehouse (2017-07-30)
- SSMS Snack: Start SSMS as different user (2017-07-01)
- Schedule Upscale/downscale Azure Analysis Services (2017-06-08)
- Schedule Start of Azure Virtual Machine (2017-06-01)
- Azure - On-premises data gateways (2017-05-15)
- Schedule Pause/Resume of Azure Analysis Services (2017-04-27)
- Schedule Pause/Resume of Azure Data Warehouse (2017-04-17)
- Schedule Upscale/downscale Azure SQL DB(/DWH) (2017-04-11)
- SSRS Snack: Excel Rendering Extension Error (2017-03-28)
- Create and populate Time Dimension (2017-01-29)
- Extracting tweets with Azure App Service - Logic App (2016-11-17)
- Extracting tweets with Microsoft Flow (2016-11-17)
- Azure - Understanding Stream Analytics Windowing Functions (2016-10-04)
- IoT Adventure: 4 - Sending sensor data to IoT Hub (2016-07-24)
- IoT Adventure: 3 - Create Visual Studio Project for sensors (2016-07-17)
- IoT Adventure: 2 - Preparing development machine (2016-07-09)
- IoT Adventure (2016-07-04)