[spacer] [spacer] [spacer]

Sign up with your email address to be the first to know about new publications

[mc4wp_form id="4946"] [spacer]

Azure SQL Analytics Pool Engine Version

In this blog post, we’ll look at getting version information from your Azure Synapse Analytics SQL pool using T-SQL.  This information could be different within databases in the same region. 

In my previous post, we defined maintenance windows for an Azure Synapse Analytics SQL Pool. It’s important to be aware of any new changes that become available and the status of your current service. 

 
To find out information about the version, engine edition, and product version, execute the following command: 

SELECT  

 [Version] = @@Version, 

 [Engine] =  SERVERPROPERTY('EngineEdition'), 

 [Product] =  SERVERPROPERTY('ProductVersion')  

The expected result will look like the row below. 

Microsfot Azure SQL Data Warehouse version, engine, product

Why is this relevant? Because you could have different versions across regions and within the same region! 
 Most times, the new product version will be applied after pausing and starting the service.

Let’s take a look at an Azure Synapse Analytics product version in the same region. 

Product version in same region

And finally, let’s check out an Azure Synapse Analytics product version in another region. You’ll find that the product version is different. 

Product version in different region

This is something that you want to take into account when working with Azure Synapse Analytics. 

How can I keep up to date with new features? 

Integrate the RSS feed from the following Microsoft Azure site with any messaging/workflow platform such as Teams or Slack, or use Power Automate. 

Review the Microsoft release notes (I’d like to see the URL matching the engine version.) 

Check Github repository commits

Summary 

We’ve seen how to get the version of Azure Synapse Analytics and check the latest update, identifying the product and engine version. 

Final thoughts 

Since I work for a technology edge consultant company, understanding how Azure Synapse Analytics features are different between databases and being up to date with any possible outages is important for me and our clients. 

What’s next? 

In upcoming blog posts, I’ll cover some other features within the data analytics space and Azure services. 

No Comments Yet.

Do you want to leave a comment?

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