Practical guides and insights for modern data practitioners
Today I finally achieved a personal target of mine to gain an interesting trio of data certifications from Microsoft. I completed this mission by passing the PL-300 exam today and gaining the Power BI Data Analyst Associate certification. Which means I have now gained the below trio of data certifications from Microsoft: Azure Data Engineer … Read more
This post accompanies a video called ‘A fast and festive introduction to Azure Data Engineering services’. Which is available to watch from the day this post is published. I made the video for this years Festive Tech Calendar. So, I thought I would write this post to accompany it so that you have an overview … Read more
In this post I want to share an alternative way to copy an Azure Data Factory pipeline to Synapse Studio. Because I think it can be useful. For those who are not aware, Synapse Studio is the frontend that comes with Azure Synapse Analytics. You can find out more about it in another post I … Read more
In this post I want to do a crash course on how to connect a local SQL Server database to Azure Synapse Analytics. So that Azure Synapse Analytics can get data from it. I thought I would do this post since I got asked last week in a meeting if this was possible. In reality, … 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
In this post I want to do a five minute crash course about Synapse Studio. Because I have recently been asked to do this by colleagues. In addition, I want to clear up some confusion about what you need to do before you can access Synapse Studio. For those who are not aware, Synapse Studio … Read more
In this post I want to cover some thoughts about the increase in demand for Azure Data Engineering roles. Because I have noticed some interesting things happening recently. One of the main reasons I am sharing this is because I am very keen to know other people’s thoughts on this. Especially since I have taken … Read more