Category: Fabric

Microsoft Fabric and SQL Community Conference 2026, the Barcelona edition

Last week was filled with talks about SQL Server and Fabric. A large portion of the community travelled to Barcelona to learn from community leaders and Microsoft on their favourite topics. I'll take you through my personal experiences and highlights. Day 0: the MVP day On Monday, you have three options, depending on your relationship … Continue reading Microsoft Fabric and SQL Community Conference 2026, the Barcelona edition →

Fabric on-demand capacity: the first experiences

If you've been following the releases announced at FabCon, you must have seen one of the bigger Fabric ones: the on-demand capacities. Now, this blogpost is based on my personal, private preview, experiences. The documentation is not yet available. I've been told it won't take long before that will be available; just as the option … Continue reading Fabric on-demand capacity: the first experiences →

Power BI: the tale of migrating a report between two tenants

Before I get started, yes, I'm going to write about Power BI. If you're not familiar with my work, the long and short of it is that I tend to keep a healthy distance from anything involving semantic models and reports. Why? In one word, pie charts. Sorry if that triggered you. But every now … Continue reading Power BI: the tale of migrating a report between two tenants →

Fabric Copy Job: Find the staging!

This week, I worked for a client using the following setup. Setup They're using SQL Server databases to store their OLTP data. They use a variety of options to authenticate. Fabric isn't using private links or anything; it connects to the data through the on-premises data gateway. Inside Fabric, we chose the Copy Job activity … Continue reading Fabric Copy Job: Find the staging! →

SQL Server REGEX_LIKE confusion

I was trying out some things to learn more about RegEx when I ran into something weird. When using REGEX_LIKE in a query, I got an error in both SQL Server and Azure SQL Hyperscale. Now, I learned what will be shared in this blog from Cláudio Silva, Greg Low, and Erland Sommarskog. They were … Continue reading SQL Server REGEX_LIKE confusion →

250 blog posts

Last week, I noticed that I published my 250th blog post. I'm not sure if it's something to celebrate (I'm not really someone who celebrates things), but it is an extra reason to write a new post. Endurance I started writing in 2018 after Brent Ozar suggested I do this. He also told me that … Continue reading 250 blog posts →

DP-700 training: Monitor semantic model refresh

As you've probably heard and read before, monitoring your Fabric environment as a whole is quite important. It really does help to know what's going on. Now, one thing I've learned over all these years is that report users do quite like their data to be as fresh and up to date as possible. And, … Continue reading DP-700 training: Monitor semantic model refresh →

Attending a Level 400 training at Microsoft.

This week, I was invited to the Microsoft office in London. The reason was a Level 400 training for Microsoft partners on Real-Time Intelligence. As I've been working with RTI on a large project for the last year, it felt natural to join this training. My objectives were not listed, but I wanted to see … Continue reading Attending a Level 400 training at Microsoft. →

DP-700 training: Choose between query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence

A three-line title that promises a lot! So let's try to simplify this a bit. In essence, this blog will cover how to make OneLake data quicker in an Eventhouse using shortcuts. The process, at a high level, is quite simple. In your eventhouse, create a shortcut to a Lakehouse, for instance. Enable query acceleration, … Continue reading DP-700 training: Choose between query acceleration for OneLake shortcuts and standard OneLake shortcuts in Real-Time Intelligence →

DP-700 training: Configure Dataflow Gen2 workspace settings (Apache Airflow)

Welcome to another instalment in the DP-700 learn series. This time we're going to talk about Apache Airflow settings. It's a little bit of a misnomer in the header, maybe, but we have to follow the titles Microsoft offers in the official curriculum. Now, before we dig into the fun techy stuff, let's familiarise ourselves … Continue reading DP-700 training: Configure Dataflow Gen2 workspace settings (Apache Airflow) →