Practical guides and insights for modern data practitioners
Recently I have taken part in various discussions about why there is an increase in demand for Data Platform automation. Mostly linked to CI/CD deployments and working in a DevOps related way. In this post I want to share my personal thoughts about this, as well as some advice. Towards the end I mention a … Read more
In this post I want to cover using Azure Test Plans with GitHub deployments. So that I can cover using them together in more detail. Partly because I mentioned it in my post about using Azure Test Plans for Data Platform deployments. Plus, it gives me a chance to show you that you can use … Read more
In this post I want to cover how you can create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using GitHub Actions. By the end of this post, you will know how to create a dacpac for a dedicated SQL Pool within GitHub Actions for your CI/CD deployments. Creating database project for Azure … Read more
In this post I want to share some advice about using GitHub CLI with GitHub Actions for Data Platform deployments. Because I showed that at SQLDay last week. About GitHub CLI For those who were not aware, there is a GitHub CLI you can use from the command line. You can download GitHub CLI from … Read more
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
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