This series of posts is much overdue, but with good reason. When I started hammering Azure SQL again, I had a set of scripts to run and tried to figure out what was happening. For most databases, I could explain the results, but some didn't make sense. I'll get back to that later in this … Continue reading Load testing SQL, the sequel. Standard Edition
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
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!
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
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
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
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
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
We're almost used to SQL Server Management Studio (SSMS) 21, and now 22 is already in preview. So, let's see where it's available for download, install it and see what's different. Download and release notes. The most important part, of course, is the download of the binaries. Click here for the download. Click here for … Continue reading SSMS 22 preview 1 first impressions
Some time ago, Microsoft announced the release of a new version of SQL Server. This made me happy, mainly because in the storm of everything Fabric, Copilot, and cloud, sturdy technology still has a place, and Microsoft hasn't forgotten that. Companies still rely on on-premises systems that require databases. And running everything on-premises is still … Continue reading My top features of SQL Server 2025 for Business Intelligence
