Practical guides and insights for modern data practitioners
This post covers how you can spread your SQL Server wings with Microsoft Fabric in 2026. As part of a long-running series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. Just after Microsoft Fabric was publicly announced during Microsoft Build 2023, I published a post that covered spreading your … Read more
In this post I show how you can use Managed DevOps Pools for Microsoft Fabric deployments. Which can be beneficial for a variety of reasons, including the ability to access secure Azure Key Vaults with firewall enabled. Like in the below diagram. This post is based on my previous post where I showed how to … Read more
This post covers how you can perform CI/CD for Fabric apps with Azure DevOps. In order to deploy efficiently with a fully working YAML pipeline. Like in the below diagram. Just to clarify, Fabric apps were announced at Microsoft Build two weeks ago. Idea is that you work with the developer toolkit called Rayfin to … Read more
This month’s T-SQL Tuesday contribution delves into the Fabric multiverse. Focusing on four different possible outcomes for the future of Microsoft Fabric. Based on the thoughts that came to my mind after reading the invite. Before I get going, I just want to make it clear that this post is both fictional and hypothetical. Apart … Read more
This post shows how you can perform Fabric CI/CD securely in GitHub with OpenID Connect and fab deploy. As visualized below. To clarify, OpenID Connect (OIDC) extends OAuth 2.0 to provide identity verification and allows GitHub Actions to securely authenticate to cloud providers using short-lived tokens instead of stored secrets. Fab deploy is a new … Read more
This post covers one way you can simplify CI/CD for Real-Time Intelligence in Microsoft Fabric with the fab deploy command in Azure DevOps. I often get asked if CI/CD for Real-Time Intelligence works. Since it is not a topic that gets discussed often. So I decided to show CI/CD working for Real-Time Intelligence and how … Read more
This post covers how you can speak to your Fabric Ontologies using voice commands. In the past I recommended chatting with your Ontologies by adding them to a Fabric data agent and then chat with your data agent in Visual Studio Code. Now there is an ontology MCP server available. So I decided to show … Read more
This months T-SQL Tuesday contribution highlights a couple of points about developing metadata-driven frameworks for Microsoft Fabric to cater for change detection. Since this months T-SQL Tuesday invitation invites us to cover change detection I decided to put my own unique spin on it. By sharing some advice about how to develop metadata-driven frameworks efficiently … Read more
This post covers testing fab deploy with the new Fabric automation tools Azure DevOps extension. Plus, I show how you can authenticate with the new Azure Devops extension in various different ways. Since it has just been released there are a few quirks with the new extension. In fact, some there are already some GitHub … Read more
This post covers using fab deploy in Azure DevOps for Microsoft Fabric deployments based on YAML pipelines. In addition, this post shows how you can perform initial tests locally and introduces some AI concepts. Plus, this post shares plenty of links and advice. You can find an example to accompany this post in the ‘create-genworkspace-fabric-cli.yml‘ … Read more