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 →

SSMS 22.6: Custom Copilot instructions

When you start using SSMS with GitHub Copilot, there is no default set of instructions in place. The agent will just sort of do what it thinks is best. But you can make sure the agent has more knowledge of your local environment (yes, it can be a cloud database as well), how it should … Continue reading SSMS 22.6: Custom Copilot instructions →

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) →

T-SQL Tuesday #199: Back to on-prem?

This month, Koen Verbeeck invites the blogging community to write about their thoughts on returning to on-premises. What could be struggles, things we have to re-learn, etcetera. When I read the invite, it immediately sparked inspiration, because there are increasing rumours around cloud exits. People musing about 'what if'. Some clients reference these questions, but … Continue reading T-SQL Tuesday #199: Back to on-prem? →

DP-800: First Microsoft Learn experiences

The DP-800 training is new and was released to GA a few weeks ago. It now sits in the same family as DP-600 (Data Analytics using Microsoft Fabric), 700 (Data Engineering using Microsoft Fabric) and 750 (Data Engineering using Databricks). The full name of this training is "Develop AI-Enabled Database Solutions". This one sparked my … Continue reading DP-800: First Microsoft Learn experiences →

Microsoft Fabric: Recover your deleted items

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 →

SSMS 22.5 and Copilot: generate code in the query window

A lot of you may probably know that I like the GitHub Copilot sidecar chat in SSMS, and that it can really help develop code faster. Even though you have to be aware of how the integration now handles your prompts, it remains a great help to quickly generate code. But did you know that … Continue reading SSMS 22.5 and Copilot: generate code in the query window →

Remember your Redundancy

Let me start this blog post by asking you a question. Q. When was the last time you looked at your redundancy? Yes, this is a very vague question because there's a lot of interpretation you can put into it. Even though it's very valid to think about your personal redundancy (who can fill in … Continue reading Remember your Redundancy →

Mirroring SQL Server 2025 to Microsoft Fabric, a level deeper

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 →

Microsoft Fabric, taking over orphaned deployment pipelines

Last week, we ran into an issue where deployment pipelines are owned by a person who no longer works for our organisation. This meant we could not access the deployment pipelines owned by this account. API The way to recover them is to use API's. At first, we all thought that using the Fabric API's … Continue reading Microsoft Fabric, taking over orphaned deployment pipelines →