Migrate serverless SQL Pool objects to a Microsoft Fabric Data Warehouse

In this post I want to cover one way you can migrate serverless SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. Since I was able to get this working. To clarify, when I say serverless SQL Pools I mean the ones that are part of Azure Synapse Analytics. Which I covered … Read more

Sql-action v2 GitHub Action for Azure SQL Database deployments

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

A complete CI/CD experience for Azure Synapse Link for SQL Server 2022

In this post I want to show you a complete CI/CD experience for Azure Synapse Link for SQL Server 2022 tables. Which uses a YAML Pipeline in Azure DevOps. Including how to automatically stop and start it in the pipeline. In a previous post I showed how an easier way to perform CI/CD for Azure … Read more

Set up your laptop as an Azure DevOps agent to test SQL Server deployments

In this post I want to cover how you can set up your laptop as an Azure DevOps agent to test SQL Server deployments. Because I have been asked about this this a lot. In reality, a lot of this post applies if you are looking to setup your computer as an Azure DevOps agent … Read more