Did you know that you could be running two different versions of Azure Synapse Analytics Dedicated SQL Pools in your environments? In this post, I’ll show you how you can find the product version of your Azure Synapse Analytics Dedicated SQL Pool.
More often than not, Microsoft releases improvements on their services. This includes Azure Synapse Analytics Dedicated SQL Pools.
These improvements release new features as soon as they are available, fix bugs, update security and more.
Because Azure Synapse Analytics is a managed service (Platform-as-a-Service / Database-as-a-Service), you have little control over when these releases are going to take place.
You can configure SQL Maintenance Windows to give MS a time window to apply changes. However, some changes will take place outside the time window.
Table of Contents
Finding the Product Version of your Azure Synapse Analytics Dedicated SQL Pool
First, to learn the product version of your Azure Synapse Analytics Dedicated SQL Pool, execute the following query:
-- Use this query to verify your product version and compare with other environments
SELECT
[Database name] = db_name(),
[Version] = @@Version,
[Engine] = SERVERPROPERTY('EngineEdition'), -- 6 Is Synapse Analytics
[Product] = SERVERPROPERTY('ProductVersion')
What to do if my product versions are different?
In some cases, pausing and resuming the Dedicated SQL Pool will help pick up the latest changes in the service.
You can also track the release changes at https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/release-notes
WHAT’S NEXT?
In upcoming blog posts, we’ll continue to explore some of the features within Azure Services.
Please follow Tech Talk Corner on Twitter for blog updates, virtual presentations, and more!
As always, please leave any comments or questions below.
Check out these other blog posts
Azure Synapse Analytics Queries #8 Concurrency Slots
How to monitor Azure Synapse Analytics concurrency slots in your Azure Synapse Analytics SQL Pools. Azure Synapse Analytics Queries #8
Azure Synapse Analytics Queries #7 Monitor Table Size
In this post, you’ll learn the queries you need to monitor table size. This information will help you understand if the table type and distribution are still suitable for your table (example: Replicated, Round-robin, Hash-distributed).
Azure Synapse Analytics Queries #6 Monitor Data Skew
In this post, you’ll learn how to monitor data skew in your Azure Synapse Analytics SQL Pool. Data skew is the uneven distribution of data.
