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
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
First up, congrats to Adam Machanic and Steve Jones on reaching 200 episodes of T-SQL Tuesday; you can be proud of yourselves! I've always loved the variety of topics, the different views of the bloggers, and the learning that can be gained from all the posts. I've even had the honour of hosting. Anyway, Brent … Continue reading T-SQL Tuesday 200: When I Look at a Query …
Earlier this year, Microsoft released a new certification that combines AI and SQL Server knowledge: the DP-800: Developing AI-Enabled Database Solutions. As I still deeply care about SQL Server and am convinced it has a very central place in any data architecture (cloud or on-premises), this one sparked a lot of interest. Today, I took … Continue reading DP-800 Exam Experiences
