Practical guides and insights for modern data practitioners
This post covers how to automate branching out to new workspace in Microsoft Fabric with GitHub. Based on custom Branch Out to New Workspace scripts for Microsoft Fabric provided by Microsoft. Which you can find in the Fabric Toolbox GitHub repository provided by Microsoft. I covered implementing it in Azure DevOps in a previous post. … 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 want to show one way that you can operationalize Fabric workspaces using Fabric CLI and fabric-cicd with GitHub Actions. To clarify, when I say the Fabric CLI I mean the Fabric Command Line Interface. Which is a command line offering by Microsoft. Whereas fabric-cicd is a Python library that allows you … 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 cover two ways to perform CI/CD for SQL databases in Fabric using GitHub Actions. By showing two different ways you can create the dacpac file with GitHub Actions. One way with a database project and another by directly extracting the schema of the database into a dacpac file. As per the … 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 performing CI/CD for SQL Server 2022 using GitHub Actions. For a couple of reasons. First one is due to the fact that last week I was answering a query on the well known SQLHelp hashtag about deploying updates to SQL Server using GitHub Actions. That is when it … Read more
In this post I want to cover using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. Which is the GitHub Action that is also known as sql-action. This post provides an overview of what is new and provides plenty of links along the way. I wanted to do this post due … Read more
In this post I cover some recommended Microsoft certifications for DevOps enthusiasts. To make people aware of some of the options that are available. In addition, I also share some recommended certification routes as well as plenty of links. Plus, I mention some non-Microsoft certifications as well. One key point to remember is that the … Read more