My previous post on load testing Azure SQL covered the General Purpose Edition, let's move it up to the Business Critical Tier The Business Critical tier comes in two flavours: General and confidential compute. For my testing, I've stuck with the General SKU. I haven't seen confidential compute with customers, and it has very specific … Continue reading Load testing SQL: the sequel. Let’s get Business Critical!
This blog post responds to Hugo's latest post, titled Game Over. On Bluesky, an initiative was started to share how Hugo inspired, helped, or otherwise touched your work or community life. Add your response using the hashtag #ThankYouHugo. There's no specific date, format, or length requirement.
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.
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
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
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
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!
