Practical guides and insights for modern data practitioners
In this post I cover two happy together paths to test semantic models in Microsoft Fabric feature workspaces with BPA. Before you deploy updates to your development environment. To clarify, when I say BPA I mean the Best Practices Analyzer functionality that you can work with to check that your semantic models are optimized and … Read more
For this months T-SQL Tuesday contribution I cover how you can improve your Data Platform integrity with CI/CD practices. Before I go any further, I want to thank Rob Farley who hosts this months T-SQL Tuesday. Rob invites us all to cover the topic of integrity. You can read the original invitation by clicking on … Read more
In this post I cover two ways to perform CI/CD for SQL databases in Fabric using YAML pipelines in Azure DevOps. By showing two different ways you can create the dacpac file with YAML pipelines. One way with a database project and another by directly extracting the schema of the database into a dacpac file. … Read more
In this post I cover two ways to perform CI/CD for SQL databases in Fabric using Azure DevOps. By showing two different ways you can create the dacpac file in Azure DevOps. One way from on a database project and another by directly extracting the schema of the database into a dacpac file. As per … Read more
For this months T-SQL Tuesday contribution I cover managing Database/SQL Pool/Data Warehouse code. To clarify, this post focuses on managing code for SQL Server databases, Azure Synapse SQL Pools and Microsoft Fabric Data Warehouses. Since they all work with T-SQL and this is a T-SQL Tuesday post. Before I go any further, I want to … Read more
In this post I cover CI/CD for Microsoft Fabric Data Warehouses using GitHub Actions. I want to do this post for various reasons. Including the fact that when I was presenting at the Microsoft office in the Netherlands earlier this year I mentioned to somebody that this can be done in GitHub. I feel now is the right time … Read more
In this post I cover how you can download a Microsoft Fabric Data Warehouse database project to perform CI/CD using Azure DevOps. In addition, how my example ADO-FabricDWDBProject GitHub repository can help you speed up the process. Which is now easier to do. Thanks to the latest option in the Warehouse Editor that allows you … Read more
In this post I cover how to perform CI/CD for Microsoft Fabric Data Warehouses using YAML pipelines. Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. To clarify, YAML pipelines are the pipelines you work with in Azure DevOps that use YAML syntax. In other words, code. … Read more
In this post I want to cover CI/CD for Microsoft Fabric Data Warehouses using Azure DevOps. Which can now be done gracefully with the new target platform thanks to a new SqlPackage update. In this post I cover the entire flow. From creating the database project all the way through to the deployment. Admittedly, I … Read more
In this post I want to cover how you can share a Microsoft Fabric Data Warehouse Database Project with the new target platform. Which is now possible thanks to the latest Azure Data Studio Insiders update. You can view the ‘Add projects support for Fabric DW‘ pull request in the public azuredatastudio GitHub repository. For … Read more