Practical guides and insights for modern data practitioners
In this post I want to raise awareness about the fact that the new Microsoft Fabric Data Warehouse Target Platform is now included as part of the latest Azure Data Studio update. Which is 1.46. In reality, I have already covered the new target platform in my previous post. Due to the fact that this … Read more
In this post I want to cover one way you can migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. I thought I better do this post since I showed how to do something similar for serverless SQL Pool objects in a previous post. To clarify, when I say dedicated … Read more
In this post I want to cover how to install SqlPackage to work with dacpacs for serverless SQL Pools. I decided to do this post after some feedback I received about SqlPackage after a series of posts about deploying dacpacs to serverless SQL Pools. For example, my post about deploying a dacpac to a serverless … Read more
In this post I want to cover how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Yes, you are reading that right. It is now possible thanks to a SqlPackage update. Which you can download this update on the ‘Download and install SqlPackage‘ page. In a previous post I covered how … Read more
In this post I want to cover performing CI/CD for SQL Server 2022 using GitHub Actions. For a couple of reasons. First one is due to the fact that last week I was answering a query on the well known SQLHelp hashtag about deploying updates to SQL Server using GitHub Actions. That is when it … Read more
In this post I want to share how I created a homemade serverless SQL Pool database project. Because I know people are keen to work this way right now. Mostly due to the comments I received when I covered how to deploy a dacpac to a serverless SQL pool. By the end of this post … Read more
In this post I want to cover deploying a dacpac to a serverless SQL pool using Azure DevOps. By showing you examples based on both classic pipelines and YAML pipelines. Yes, you are reading that right. It is now possible to do achieve this with database projects thanks to a SqlPackage update. You can download … 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 how you can create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using Azure DevOps. By the end of this post, you will know how to create a dacpac for a dedicated SQL Pool within Azure Pipelines for your CI/CD deployments. Plus, how you can synchronize … 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