Practical guides and insights for modern data practitioners
Consider this post as an introduction to upcoming spreading your SQL Server wings with the Microsoft Intelligent Data Platform series that I will be publishing. I want to publish this post to raise awareness about a series of future posts that are coming. Plus, I want to make those posts more efficient by sharing a … Read more
In this post I want to cover common Azure Synapse Link for SQL storage permission issues. Since I helped a fellow MVP out with this recently. To be more precise, I want to show how you can fix one of the most common issues I tend to encounter with Azure Synapse Link for SQL. Which … Read more
In this post I want to cover performing CI/CD for SQL Server 2022 using GitHub Actions. For a couple of reasons. First one is due to the fact that last week I was answering a query on the well known SQLHelp hashtag about deploying updates to SQL Server using GitHub Actions. That is when it … Read more
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
Last week I did some initial tests for Azure Synapse Link for SQL Server 2022. Which is currently in preview. In addition, I showed a working version of it at Data Saturday Croatia. With this in mind, I thought I would share some of my experiences with it so far. By the end of this … Read more
In this post I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases. Just to clarify, a dacpac file is a special type of file which contains details about SQL Server database … Read more