Practical guides and insights for modern data practitioners
In this post I want to show you a complete CI/CD experience for Azure Synapse Link for SQL Server 2022 tables. Which uses a YAML Pipeline in Azure DevOps. Including how to automatically stop and start it in the pipeline. In a previous post I showed how an easier way to perform CI/CD for Azure … Read more
In this post I want to cover a Data Platform area I recently recommended to a colleague. Since the answer surprised me. A while back a colleague who is studying for Azure Data Platform certifications mentioned that there were a lot of areas they could focus on after their exams. They then asked me if … Read more
In this post I want to cover a much easier way to perform CI/CD for Azure Synapse Link for SQL Server 2022 using Azure DevOps than I showed before. Azure Synapse Link for SQL Server 2022 recap Just to recap, Azure Synapse Link for SQL Server 2022 transfers data from a SQL Server 2022 database … Read more
For this months T-SQL Tuesday contribution I want to cover my Azure Synapse Link for SQL Server 2022 testing. Since we have been invited to discuss SQL Server 2022 this month. Glenn Berry hosts this months T-SQL Tuesday. Glenn invites us to write about what we have been doing with SQL Server 2022. You can … Read more
In this post I want to cover some things that happen internally when you do updates and deletes with Azure Synapse Link for SQL Server 2022 whilst it is running. Because recently somebody asked if Azure Synapse Link for SQL Server 2022 captures updates and deletes after they had read a previous post. Where I … Read more
In this post I want to cover some file tests for Azure Synapse Link for SQL Server 2022 that I performed. Because a while back I spotted something interesting whilst I was doing some initial tests for Azure Synapse Link for SQL Server 2022. Which is when you add new data after the initial load … Read more
This post covers one way to update both ends of Azure Synapse Link for SQL Server 2022 using Azure DevOps. By the end of this post you will know one to deploy database updates to both the SQL Server database and the Azure Synapse dedicated SQL Pool that are used as part of Azure Synapse … Read more
You can consider this post to be a follow up to my Data Toboggan session on how you can create a database project for use with Azure Synapse Link for SQL Server 2022. This post covers the below: As promised during Data Toboggan a diagram is included in this post. In the next post I … Read more
In this post I want to cover my route to passing the DP-500 exam. Because I found out last Friday that I passed the beta exam for it. Just to recap, the DP-500 exam is a new exam which mostly focuses on Power BI and Azure Synapse Analytics. By passing the exam I have gained … Read more
In this post I want to cover some of the ways I have been looking to improve my GitHub hygiene for Microsoft Data Platform repositories. By following some best practices. To clarify, GitHub hygiene is a term that I use to describe the practice of keeping GitHub repositories healthy. Some of you have probably noticed … Read more