How to Install Integration Services 2022

2 years ago

The title of this blog post is a bit misleading, because what we actually want to do is to install…

Read data from Azure Synapse Serverless SQL Pools with Azure Data Factory

2 years ago

We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post,…

How to Store Normalized SQL Server Data into Azure Cosmos DB

2 years ago

Recently I got a hold of my Untappd data. For those who don't know the app, it's a rating app…

Session Materials – PASS Data Community Summit and Cloudbrew

2 years ago

You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate…

How to Install SQL Server 2022

2 years ago

SQL Server 2022 has been released! In this blog post, I'll walk you through how you can install the latest…

Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching

2 years ago

At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa…

Granular Cost Management for Azure Data Factory

2 years ago

A new feature has been launched that allows you to have more granular control over the execution costs of your…

Session Materials for dataMinds Connect 2022

2 years ago

You can find the slides and the demo scripts (.sql files) in my Github repo. You can use the materials…

How to Calculate Compound Rate in Power BI

2 years ago

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound…

Power BI Desktop overwrites Authentication Settings in Similar Connections

2 years ago

Yesterday I was facing an annoying issue. I have two Power BI datasets. Both connect to the same Azure SQL…