SSMS 22 Copilot: using a model on my laptop

When I looked at the latest version of SSMS 22, I found that there's now an option to add your own model. You're no longer required to use GitHub Copilot. In an earlier blog, I posted about how you can add a model in Microsoft Foundry. So this time, I'm going to host one on … Continue reading SSMS 22 Copilot: using a model on my laptop →

MS Ignite 2026, AI, IQ, and data?

Yesterday, I was watching the Microsoft Ignite keynote; you can find it here. The complete Book of News is here. What stood out to me was how much there is talk about AI. Copilot, Autopilot, GitHub Copilot, Windows Autopilot, and what have you. As I'm no AI expert, it's starting to feel like a blur. … Continue reading MS Ignite 2026, AI, IQ, and data? →

SSMS 22: a few wonderful updates

When I opened SSMS today (November 18th, 2026), I found that the wonderful team keeping this tool up to date and running has added some excellent updates. Updates that deserve more attention. GitHub Copilot: bring your own model First of all, you can now bring your own model to SSMS. You're no longer dependent on … Continue reading SSMS 22: a few wonderful updates →

Oh No! My files are in the wrong encoding!

The post discusses common issues with file encoding when using PowerShell, specifically when logs appear corrupted or unintelligible. It provides a solution by ensuring commands use UTF-8 encoding and includes a PowerShell script that repairs damaged files by converting UTF-16 data back to UTF-8, enabling proper data recovery.

Dipping my toes into Azure DevOps Deployments

That's a lot of D's. It's also my rating; people like Kevin Chant rate at least an A. Anyway, Kevin has written a lot about working with CI/CD; I'm here to clarify what I ran into while building a solution to deploy Fabric code from the Dev environment (a set of workspaces) to production. This … Continue reading Dipping my toes into Azure DevOps Deployments →

Fabric Capacity Metrics App, a huge upgrade!

In case you missed it, Microsoft released a new version of the Metrics App. We all know the current one, and we have opinions on it. But it's all we've got from Microsoft, so we made do. But now, there's a new one. Or, well, a new one. When you install a new version, you … Continue reading Fabric Capacity Metrics App, a huge upgrade! →

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 →

Azure: Check your data platforms resiliency

Wait, what? Resiliency? Against what? Well. The cloud sounds like an amazing, magical place without limits. The truth is, it isn't. Maybe you've seen the funny T-shirts with the text "the cloud is just someone else's computer". And that's true. Instead of building and maintaining your own data centre, you're hiring a global corporation to … Continue reading Azure: Check your data platforms resiliency →

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