Kevin Chant gives us the whole story:
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 Synapse Link for SQL Server 2022. Where you only need to stop the link, update the SQL Server database and afterwards start the link again.
However, the best CI/CD solutions are the ones where you do not do any manual work at all. This includes stopping and starting the link.
And that’s just what Kevin gives us.