Practical guides and insights for modern data practitioners
This post is a back-to-basics Git introduction for Microsoft Fabric enthusiasts. Because I am very aware a lot of Microsoft Fabric enthusiasts are from different backgrounds. Which means that Git may not be their focus area. To manage expectations, this post is aimed at those with little or no experience of Git. However, those with … Read more
In this post I want to cover the results of some interesting tests I did with the allow list for Databricks Repos. In short, Databricks Repos is a reasonably new feature in Azure Databricks which allows you to work on a complete set of files that are stored in a Git repository. To find out … Read more
In this post I want to cover how to do version control for SQL Server Management Studio templates using Azure Repos. I wanted to do this post for various reasons. However, I am mostly doing this post because my post about using version control for SQL Server Management Studio templates has been viewed nearly every … 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 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
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 potential issues if renaming your main GIT branch in Azure DevOps. Because I have encountered a few issues doing this myself. Of course, there has been a lot of discussions about whether you should start renaming your master branch to main recently. Personally, I have decided to do … Read more
In this post I thought I would talk about using version control for SQL Server Management Studio templates. In addition, I will mention other applications you can do the same with towards the end. I wanted to write this post because in a previous post I discussed how SQL Server Professionals can benefit from using … Read more
In this post I thought I would talk about how SQL Server Professionals can benefit from using version control systems. Mostly because I have been involved in some discussions about it recently. I say SQL Server Professionals here because I want it to be all inclusive. Due to the fact this applies to database administrators … Read more