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 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