Practical guides and insights for modern data practitioners
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 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 using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. Which is the GitHub Action that is also known as sql-action. This post provides an overview of what is new and provides plenty of links along the way. I wanted to do this post due … Read more
In this post I want to cover CI/CD for serverless SQL Pools resources that I have either created or been a part of. For one very good reason. Last week the January 2023 video of the Azure Synapse Analytics and Microsoft MVP series was released. Where covered how to do CI/CD for dedicated SQL Pools … Read more
In this post I want to share some recommended Azure Synapse Analytics certifications. For those who are keen to gain certifications about it or just want to learn more about the service. In a previous post I provided some advice if Microsoft certifications are your New Year’s resolution. Since I covered Azure Databricks certifications in … Read more
In this post I want to cover where you can find Azure Data Factory objects in Synapse Studio. I want to do this post for a couple of reasons. First reason is that at the start of the year I published a post on how to automate a Data Factory pipeline migration to an Azure … Read more
My Festive Tech Calendar 2022 contribution was released this week. It is a video available on YouTube called “Viewing a list of Christmas presents from Azure Data Engineering services“. Which shows how can query Christmas presents which are stored in csv or parquet files using Azure Databricks and Azure Synapse Analytics. Plus, I cover Delta … Read more
In this post I want to do a six-minute crash course about Synapse Studio. I wanted to do this follow-up post for a couple of reasons. First reason is because a while ago somebody who was fairly new to Azure Data Engineering Services mentioned that they thought a lot of my posts were for advanced … Read more
In this post I want to show how a GitHub CI/CD experience for Azure Synapse Link for SQL Server 2022 can look. Which uses GitHub Actions. Including how to automatically stop and start it in the pipeline. In my last post I showed a complete CI/CD experience for Azure Synapse Link for SQL Server 2022 … Read more