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

3 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

3 years ago

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

Speaking Engagements for Fall 2022

3 years ago

The summer holiday is almost over, and this means conference season will be back in full swing again. I'll be…

Cool Stuff in SQL Server 2022 – IS DISTINCT FROM

3 years ago

I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is…

Free Webinar – T-SQL Best Practices and Tuning for the BI/DWH Developer

3 years ago

I'm giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract: When building a data warehouse (DWH)…

SharePoint List only returns 100 items in Azure Logic App

3 years ago

I was reading a SharePoint List using the "Get Items" activity in an Azure Logic App. I explain how you…