Skip to content

T-SQL Tuesday 159 – Azure Synapse Link and certifications

Reading Time: 2 minutes

For this months T-SQL Tuesday contribution I want to cover Azure Synapse Link and certifications.

In addition, this post contains plenty of links.

Community superhero Deepthi Goguri hosts this months T-SQL Tuesday. Deepthi invites us to blog about two topics this month.

  1. Blog about a new feature in SQL Server 2022 or Azure.
  2. What are our New Year’s resolutions.

You can read the original invitation by clicking on this link for the T-SQL Tuesday 159 invitation or on the image below.

T-SQL Tuesday logo
T-SQL Tuesday logo

Azure Synapse Link

My first topic is about a new feature that covers both SQL Server 2022 and Azure. Which is Azure Synapse Link, or to be more precise Azure Synapse Link for SQL Server 2022.

I have been doing various tests with this feature recently. Which has led to some interesting blog posts about Azure Synapse Link for SQL Server 2022.

Including one where I performed some interesting file tests for Azure Synapse Link for SQL Server 2022. Because I was curious to see what happened when you inserted one hundred million rows into a table whilst Azure Synapse Link for SQL Server 2022 was running.

In fact, I updated the below Git repositories that I have made available in GitHub over the weekend. Which are available for anybody to clone or download.

Main updates are that they both contain a new YAML file. Which I will cover in a later post.

However, I can reveal that both the of these new files will build (create) a dacpac file first in either Azure Pipelines or GitHub. Before attempting to stop the link. As per the below example from Azure DevOps.

Azure Pipelines deployment with build done first as part of a complete CI/CD experience for Azure Synapse Link for SQL Server 2022
Azure Pipelines deployment with build done first


Now it is time to cover topic number two. Even though I have some minor New Year’s resolutions my main one is definitely certifications. I intend to gain new ones and renewing existing ones.

I must admit writing some recent blog posts about recommended certifications has made me more determined to gain some new ones.

Ironically, writing those posts took up some of my study time. But I wanted to publish those certification posts as close to the start of the year as possible. To help others who wanted to gain certifications as part of their New Year’s resolutions.

I have started renewing my existing Microsoft certifications. By renewing my Azure Database Administrator Associate certification the other weekend.

Final words

I hope my T-SQL Tuesday contribution about Azure Synapse Link and certifications has made for interesting reading.

Thanks again Deepthi for hosting this months T-SQL Tuesday.

Of course, if you have any comments or queries relating to this post feel free to reach out to me.

Published inUncategorized

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *