In this post I want to cover CI/CD for serverless SQL Pools resources that I have either created or been a part of. For one very good reason.
Last week the January 2023 video of the Azure Synapse Analytics and Microsoft MVP series was released. Where covered how to do CI/CD for dedicated SQL Pools in Azure Synapse Analytics.
Since the release of that video the most popular question raised has been how to perform CI/CD for serverless SQL Pools within Azure Synapse Analytics?
By the end of this post, you will know plenty of CI/CD for serverless SQL Pools resources. Plus, this post contains plenty of links.
CI/CD for serverless SQL Pools using Azure DevOps
My first post relating to this covered performing CI/CD for serverless SQL pools using Azure DevOps. This is the first post where I go into detail about using the dbops PowerShell module with Azure DevOps.
I did some follow-up posts after this one.
For instance, last year I did a post which introduced the dbops PowerShell module for Azure DevOps deployments. As part of the community tools awareness month, which was an initiative suggested by Brent Ozar. That post contains additional advice about variable groups.
I also created a public repository that is available in GitHub that you can use as a template to perform CI/CD in Azure DevOps. It is called ADO-SynapseServerlessSQLPool-migration. Which anybody can download from GitHub and use.
Feel free to give the repository a star in GitHub if it proves to be useful.
CI/CD for serverless SQL Pools using GitHub
I did another post that covered how to perform CI/CD for serverless SQL pools using GitHub Actions.
In that post I also showed how to add sensitive information as secrets. Since then I have published another post that shows various ways that you can keep your Azure Synapse secrets secret in GitHub.
I have also made available a repository that you can use as a template to perform CI/CD for serverless SQL Pools using GitHub Actions as well. It is called GH-SynapseServerlessSQLPool-migration.
CI/CD for serverless SQL Pools videos
Now, the most recent video relating to CI/CD for serverless SQL Pools was for the November 2022 edition of the Azure Synapse Analytics and Microsoft MVP series. Which covered using CI/CD for Serverless SQL Pools in Azure Synapse Analytics and includes a demo of a pipeline in action.
Final words
I hope this post covering CI/CD for serverless SQL Pools resources helps some of you. Since it has been a popular question over the last week.
Of course, if you have any comments or queries about this post feel free to reach out to me.