Practical guides and insights for modern data practitioners
In this post I cover some options for deploying to Development, Test and Production environments in Microsoft Fabric. I wanted to do this post since I still see a lot of questions about this topic. So, I wanted to provide some solid options as to what you can use to deploy to different environments. By … Read more
In this post I want to cover how you can create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure Data Studio. Because somebody asked if it’s possible to create a dacpac for a SQL Pool a while back. Using the #SQLHelp hashtag on Twitter. In fact, it was asked whilst I … Read more
In this post I want to cover more thoughts about SQL Server professionals using version control. Because I have had some interesting conversations since my last post about it. In a previous post I covered how SQL Server professionals can benefit from using version control. Which you can read in detail here. Now I want … 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