One YAML pipeline for many Azure Synapse environments in Azure DevOps

In this post I want to raise awareness about how you can use just one YAML pipeline for many Azure Synapse environments in Azure DevOps. Instead of creating multiple YAML pipelines for different environments. To clarify, when I say YAML pipelines I mean the YAML pipelines you work with in Azure Pipelines service within Azure … Read more

Connect a Database Project in Azure Repos to Azure Pipelines

During SQLBits one of the attendees mentioned that the missing link for them was how to connect a Database Project in Azure Repos to Azure Pipelines. With this in mind, I thought I would cover how you do that in this post. Even though it can potentially spark a debate about whether to create pipelines … Read more

SQL Server installation options to test Azure DevOps deployments locally

In this post I want to cover SQL Server installation options to test Azure DevOps deployments locally. Because I have been asked about this. By end of this post, you will know various options to install SQL Server locally. Which you can use to test deploying SQL Server updates to local databases using Azure DevOps. … 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