Install SqlPackage to work with dacpacs for serverless SQL Pools

In this post I want to cover how to install SqlPackage to work with dacpacs for serverless SQL Pools. I decided to do this post after some feedback I received about SqlPackage after a series of posts about deploying dacpacs to serverless SQL Pools. For example, my post about deploying a dacpac to a serverless … Read more

Homemade serverless SQL Pool Database Project

In this post I want to share how I created a homemade serverless SQL Pool database project. Because I know people are keen to work this way right now. Mostly due to the comments I received when I covered how to deploy a dacpac to a serverless SQL pool. By the end of this post … Read more

Deploying a dacpac to a serverless SQL pool

In this post I want to cover deploying a dacpac to a serverless SQL pool using Azure DevOps. By showing you examples based on both classic pipelines and YAML pipelines. Yes, you are reading that right. It is now possible to do achieve this with database projects thanks to a SqlPackage update. You can download … Read more

CI/CD for serverless SQL pools using GitHub Actions

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

CI/CD for serverless SQL pools using Azure DevOps

I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using Azure DevOps in this post. Because I know it is a popular topic. It is related to my post about how you can create a dacpac for an Azure Synapse Analytics dedicated SQL pool using Azure DevOps. … Read more