Skip to main content

Posts

Showing posts from March, 2017

T-SQL to get Azure SQL Database Edition and Service Objective

SELECT  @@VERSION        AS AzureVersion , DATABASEPROPERTYEX(DB_NAME(), 'Edition')      AS AzureEdition , COALESCE(DATABASEPROPERTYEX(DB_NAME(), 'ServiceObjective'), 'N/A in v11') AS AzureTier Returns: Microsoft SQL Azure (RTM) - 12.0.2000.8   Feb  8 2017 04:15:27   Copyright (C) 2016 Microsoft Corporation. All rights reserved. Premium  P1