Azure Data Platform · Azure Services · Data Engineering · Did you Know! · Q & A · Real Scenario Logic's

Question and Answer #5

Question –

Out of below 2 servers, We need to find which one is ‘Microsoft Azure Synapse Analytics’? Other might be ‘SQL Database’.
1️⃣ “s1.database.windows.net
2️⃣ “s2.database.windows.net

How to find?

💡

  • For “Dedicated SQL pool (formerly SQL DW)” , the endpoint would be same as SQL Database “.database.windows.net” [Still pricing tier is different: cDWU vs DTU/vCore]
  • Under “Azure Synapse Workspace” – created “Dedicated SQL pool”, the endpoint would be “.sql.azuresynapse.net
  • Under “Azure Synapse Workspace” – created “Serverless SQL pool”, the endpoint would be “-ondemand .sql.azuresynapse.net

🙋

By knowing “Database Engine edition of the instance of SQL Server installed on the server”, we can find this.

How to know that?

Run below SQL Query: 

SELECT SERVERPROPERTY ('EngineEdition'); 

that would return integer value:
5 => means “SQL Database
6 => means “Microsoft Azure Synapse Analytics
8 => means “Azure SQL Managed Instance
11 => means “Azure Synapse serverless SQL pool

Check the full list here: [Property: EngineEdition]

Follow Blog and Show your Support for many more interesting upcoming Posts!

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s