Practical guides and insights for modern data practitioners
After my last post I wanted to test deploying to Azure SQL Database using GitHub Actions. To check that it all runs smoothly. By the end of this post, you will have some ideas about how you can deploy Azure SQL Databases using GitHub Actions. Both for a basic test and more complex deployments. In … Read more
Since I showed how to deploy SQLWATCH to SQL Server using Azure DevOps it’s only fair I cover how to deploy SQLWATCH to SQL Server using GitHub Actions as well. In the post here I showed how you can to deploy SQLWATCH using Azure DevOps. However, since the source for SQLWATCH is in GitHub I … Read more
In this post I want to cover common questions about migrating to Azure DevOps for SQL Server deployments. Because I got asked a fair few at SQLBits last week. In fact, some people in the DevOps & PowerShell chat room kept me busy with their questions. Of course, I don’t mind because I enjoy sharing … Read more
In this post I want to cover implementing your first database deployment pipeline as a team. Because I was asked about this the other day. Now this post applies to whether you are building a database deployment pipeline for the first time ever or migrating to a new service which offers this. Of course, this … Read more
I want to share some tips about using both Azure DevOps and GitHub together for SQL Server deployments in this post. So that they help others. Just a quick recap. In a previous post here, I showed how I deployed SQL Server updates in Azure DevOps. Followed by the repository synced over to GitHub. After … Read more
In this post I want to cover using the same dacpac for Azure Pipelines and GitHub Actions deployments. Because it is something I have done a demo about recently and can be useful. Recap Just a quick recap about what Azure Pipelines and GitHub Actions are. Azure Pipelines is a service within Azure DevOps that … Read more