Homemade serverless SQL Pool Database Project

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

Deploying a dacpac to a serverless SQL pool

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

Using Azure SQL Deploy v2 for dedicated SQL Pool deployments

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

Updates about exam pages for Azure certifications

I want to cover some updates about exam pages for Azure certifications in this post. To share two important updates since my previous post about making the most out of certification pages for Azure exams. Skills measured for exams changing this month First update is very important for anybody who is currently studying for a … Read more

CI/CD for serverless SQL Pools resources

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

Recommended Azure Synapse Analytics certifications

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

Data Factory objects in Synapse Studio

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

Festive Tech Calendar 2022 contribution

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

Six-minute crash course about Synapse Studio

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

A GitHub CI/CD experience for Azure Synapse Link for SQL Server 2022

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