Practical guides and insights for modern data practitioners
In this post I share some things to consider when choosing Azure DevOps or GitHub for Microsoft Fabric Git integration. Since you can now choose either Azure DevOps or GitHub as a provider for Git repositories. As shown in the below diagram. I wanted to do this post since I get asked a lot whether … 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 share my initial thoughts about security considerations when using GitHub with Microsoft Fabric Git integration. Since GitHub support for Microsoft Fabric Git integration is now available. Allowing you to perform scenarios like the one below with multiple workspaces. Which is very similar to the Azure DevOps alternative that I shared in … Read more
In this post I share the results of some additional security tests when using GitHub for Microsoft Fabric Git integration. Which I performed recently after being asked about a couple of topics. By the end of this post, you will know the consequences of multiple users updating items in the same workspace with the same … Read more
In this post I share the results of my initial tests of GitHub support for Microsoft Fabric Git integration. Which became available in my tenant last week. To be honest, I have been looking forward to this option ever since the announcement that it was coming at the Microsoft Fabric Community Conference for various reasons. … Read more
In this post I want to cover some interesting Microsoft Fabric repositories publicly available in GitHub. I wanted to do this post after last weeks announcement about Semantic Link at the Microsoft Power Platform Conference. Since the number of useful repositories for Microsoft Fabric has now grown. In reality, I do not cover every single … Read more
In this post I want to cover spreading your SQL Server wings with dedicated SQL Pools. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. Since I covered Azure Synapse Analytics in my previous post I thought I would go a bit deeper into dedicated … Read more
In this post I want to cover how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Yes, you are reading that right. It is now possible thanks to a SqlPackage update. Which you can download this update on the ‘Download and install SqlPackage‘ page. In a previous post I covered how … Read more
In this post I want to cover using the sql-action v2 GitHub Action for Azure SQL Database deployments using GitHub Actions. Which is the GitHub Action that is also known as Azure SQL Deploy. Back in 2020 I did a post about how to deploy to Azure SQL Database using GitHub Actions. Afterwards, I shared … Read more