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
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!
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
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.
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
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)
Let's be honest: how many times have you accidentally deleted something? Either on your laptop, in a database or in a SaaS product. It happens. We're all humans (unless you allow agents to do all your work for you), and mistakes happen. Until recently, when you deleted an item in Fabric, it was gone. Poof. … Continue reading Microsoft Fabric: Recover your deleted items
Maybe you've read my blog post in the DP-700 certification series about mirroring data. You can find that one here. This blog will be longer and more technical. And involve SQL Server. To make reading a little easier, I've listed the Microsoft Learn pages at the end of this blog post. While writing the DP-700 … Continue reading Mirroring SQL Server 2025 to Microsoft Fabric, a level deeper
I've been working for quite some time on a fun solution in Fabric Realtime Intelligence. We're processing XML files into a structured table. As you're probably aware, XML has its own... well, let's be nice and call them challenges. One thing I ran into was that an element contained several other elements. Usually, you'll see … Continue reading Microsoft Fabric Realtime Intelligence: Processing XML, or are you?
Let's be honest, you thought of doing this yourself. Connecting two tools that seem to serve very different purposes. But, as I had a day to fool around, I thought to myself, let's see if I can make this work. In the previous blog post on MCP Local, I described how to run your MCP … Continue reading SQL MCP: Local to Fabric Lakehouse
