Practical guides and insights for modern data practitioners
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 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
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
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
For this months T-SQL Tuesday contribution I want to share some of my thoughts about SQL Server upgrades. Including ones for SQL Server 2019 and SQL Server 2022 (which is due to be released in near future). This months T-SQL Tuesday is hosted by Steve Jones. Steve has invited us to discuss our thoughts about … Read more