Practical guides and insights for modern data practitioners
In this post I want to cover spreading your SQL Server wings with Azure SQL Database. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. You can find out more about this series of posts in an introductory post I published about the series. By … Read more
In this post I want to cover using the sql-action v2 GitHub Action for Azure SQL Database deployments using GitHub Actions. Which is the GitHub Action that is also known as Azure SQL Deploy. Back in 2020 I did a post about how to deploy to Azure SQL Database using GitHub Actions. Afterwards, I shared … Read more
In this post I introduce the dbops PowerShell module for Azure DevOps deployments as part of the community tools awareness month. Which is an initiative that was suggested by Brent Ozar for this month. Brent invites us all this month to introduce a free tool to everybody and to share some things about it. Years … Read more
In this post I want to cover some significant updates to an Azure SQL Database repository that I have been doing for one of the public GitHub repositories that I share. Due to the fact that I have updated the ADO-AzureSQLDatabase repository. Which contains an example of a SQL Server database project that you can … Read more
In this post I want to cover how you can keep your Azure Synapse secrets secret in Azure DevOps. Because you need to do this if you are working with production deployments. With this in mind, I want to raise more awareness about it and make sure others avoid putting secrets directly in their pipelines … Read more
In this post I want to cover reasons to learn GitHub if using Azure DevOps. Because I think it is an important topic to cover. I want to give people food for thought in this post. However, I do have other reasons as well. One of which I will cover later in this post. Those … Read more
In this post I want to cover a couple of ways you can update a Database Project within the GitHub website. Because both ways can be useful. I know most of the time files are updated using development tools on your own computer. However, it can be useful to know how you can update files … Read more
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
For my T-SQL Tuesday contribution this month is I want to introduce my Azure DevOps templates for Data Platform deployments. This months T-SQL Tuesday is hosted by Frank Geisler. Frank has invited us to write about deploying SQL components through descriptive methods and build some new cool templates for them. Which is good timing for … Read more
I want to cover deploying to multiple SQL Server database types using Azure DevOps faster. because I have done this recently. In fact, I done it for the pipeline I discussed in a previous post. Which was able to deploy updates to multiple database types after updating one single database project. You can read that … Read more