Practical guides and insights for modern data practitioners
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
In this post I cover an alternative way you can authenticate as a service principal to run a Microsoft Fabric notebook using GitHub Actions. By authenticating through the Fabric CLI (Command Line Interface) to run the notebook. Some time ago I covered how to authenticate as a service principal to run a Microsoft Fabric notebook … Read more
I am really excited about introducing the “Deploy Microsoft Fabric workspace items with fabric-cicd” GitHub Action in this post. Which appears to be the first Microsoft Fabric related GitHub Action to be made available in the GitHub Marketplace. This GitHub Action will save a lot of effort when looking to move Microsoft Fabric items from … Read more
In this post I cover managing Microsoft Fabric connections with Fabric CLI when performing CI/CD. To clarify, I mean the Microsoft Fabric connections that you work with when you select “Manage connections and gateways” in the settings menu in Microsoft Fabric. Like in the below image. When I say the Fabric CLI I mean the … Read more
In this post I want to show how you can operationalize fabric-cicd to work with Microsoft Fabric and GitHub Actions. Since I got asked if this post was available whilst helping at the ask the experts panel during the Microsoft Fabric Community Conference. Just so that everybody is aware, fabric-cicd is a Python library that … Read more
In this post I want to cover one way you can get GitHub Actions information using the GitHub connector in Power BI. I want to cover this to help others who are looking to use the Power BI connector to get GitHub Actions information. With this in mind, by the end of this post you … Read more
In this post I want to provide a couple more tips about using Azure Test Plans with GitHub deployments. Since I have been asked a couple of times about this since the SQLBits conference. In reality, I did a post a while ago about using Azure Test Plans with GitHub deployments. Plus, I covered it … Read more
In this post I want to cover how to do version control for SQL Server Management Studio templates using GitHub. I wanted to do this post for various reasons. Previously I wrote a post about how to do version control for SQL Server Management Studio templates using Azure Repos. I wanted to highlight some things … Read more
I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using GitHub Actions in this post. For various reasons. For a start, in a previous post I wrote about how you can CI/CD for serverless SQL pools using Azure DevOps. So, I thought I would balance things out … Read more
In this post I want to cover a couple of ways you can update a Database Project within the GitHub website. Because both ways can be useful. I know most of the time files are updated using development tools on your own computer. However, it can be useful to know how you can update files … Read more