How to check if I "Upgrade Azure SQL Database 2014-04-01 APIs" applies to me?

Question

How to check if I "Upgrade Azure SQL Database 2014-04-01 APIs" applies to me?

Dan Chan 91

I got this email notification.

User's image

Does it apply to me? How should I check?

We have a few Azure SQL databases in our tenant. We usually interact with them through database connection. These not are APIs, are they?

Thanks.

dchan

Uwe Fuchs 140 Reputation points

2024-08-26T21:24:10.1966667+00:00
You can use Azure Resource Graph Explorer to query for resources interacting with deprecated API versions. Below is a sample Kusto query to filter HTTP incoming requests by API version:

HttpIncomingRequests | where TIMESTAMP > ago(30d) | where targetResourceProvider == 'MICROSOFT.SQL' | where subscriptionId == 'update-this-to-your-subid' //make sure you update this | where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

Note: The HttpIncomingRequests table is typically used for tracking HTTP requests handled by Azure services. You can use this query when you have Azure services like API Management, Azure Functions, or other HTTP-triggered services interacting with your resources. This will allow you to monitor and identify any usage of deprecated API versions.

To use this query:

Search for "Resource Graph Explorer" on the Azure portal.

Open Resource Graph Explorer and paste the query into the query window.

Execute the query to see if any resources are using the deprecated API versions.

To clarify, I wrote out the response myself and used AI (ChatGPT) to polish it up for better clarity. And of course, I’ve double-checked everything to make sure it’s accurate.
Dan Chan 91 Reputation points

2024-08-26T21:34:10.92+00:00

Hi @Uwe Fuchs @Uwe Fuchs ,

I copy the query you provided and put it in "Azure Resource Graph Explorer". I got the above error.....

Any idea?

Dchan
Uwe Fuchs 140 Reputation points

2024-08-26T22:42:26.8166667+00:00

I've clarified my comment to emphasize that this is applicable only when you have Azure services like API Management, Azure Functions, or other HTTP-triggered services interacting with your resource.

If you're only connecting to Azure SQL Database through connection strings in tools like SQL Server Management Studio (SSMS), Azure Data Factory (ADF), and similar resources, it's generally safe to assume that you're not directly interacting with deprecated APIs. These tools typically use standard connection protocols (like TDS for SQL Server) rather than specific REST APIs that might have deprecated versions.

However, if your ADF pipelines or other resources indirectly interact with Azure services through APIs (e.g., using HTTP-triggered functions or REST API calls), you might want to verify that those interactions aren't using deprecated versions. But for direct database connections using connection strings, deprecated API versions wouldn't be a concern.

I hope this helps.
Uwe Fuchs 140 Reputation points

2024-08-26T23:06:35.7866667+00:00

Please see this similar post https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0. You might also consider reaching out to Microsoft directly for further confirmation.
Dan Chan 91 Reputation points

2024-08-27T02:50:30.71+00:00

Hi @Uwe Fuchs ,

Thanks for your responses.

We use Cold Fusion and PowerPlatform (PowerAutomate, PowerApps, PowerBI) to interact with our Azure SQL databases. So, I guess we should be safe.

But, to ensure this API deprecation does not affect us, we should contact Microsoft about it. I will plan to do it.

Thanks.

dchan
Joanne Hatton 0 Reputation points

2024-08-27T08:49:40.0266667+00:00

Hi I received the same error and have the same problem - any clarification would be helpful.

Joanne
Uwe Fuchs 140 Reputation points

2024-08-27T19:43:57.0266667+00:00

@Joanne Hatton can you confirmhow your SQL is configgered (i.e., Azure SQL Database, VM hosted, etc.), and how you are connecting to it?
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-09-25T04:02:52.4366667+00:00

@Dan Chan
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Uwe Fuchs 140 Reputation points

2024-08-26T21:24:10.1966667+00:00

You can use Azure Resource Graph Explorer to query for resources interacting with deprecated API versions. Below is a sample Kusto query to filter HTTP incoming requests by API version:

HttpIncomingRequests | where TIMESTAMP > ago(30d) | where targetResourceProvider == 'MICROSOFT.SQL' | where subscriptionId == 'update-this-to-your-subid' //make sure you update this | where apiVersion == "2014-04-01" or apiVersion == "2014-01-01" or apiVersion == "2014-04-01-preview"

Note: The HttpIncomingRequests table is typically used for tracking HTTP requests handled by Azure services. You can use this query when you have Azure services like API Management, Azure Functions, or other HTTP-triggered services interacting with your resources. This will allow you to monitor and identify any usage of deprecated API versions.

To use this query:

Search for "Resource Graph Explorer" on the Azure portal.

Open Resource Graph Explorer and paste the query into the query window.

Execute the query to see if any resources are using the deprecated API versions.

To clarify, I wrote out the response myself and used AI (ChatGPT) to polish it up for better clarity. And of course, I’ve double-checked everything to make sure it’s accurate.
Dan Chan 91 Reputation points

2024-08-26T21:34:10.92+00:00

Hi @Uwe Fuchs @Uwe Fuchs ,

I copy the query you provided and put it in "Azure Resource Graph Explorer". I got the above error.....

Any idea?

Dchan
Uwe Fuchs 140 Reputation points

2024-08-26T22:42:26.8166667+00:00

I've clarified my comment to emphasize that this is applicable only when you have Azure services like API Management, Azure Functions, or other HTTP-triggered services interacting with your resource.

If you're only connecting to Azure SQL Database through connection strings in tools like SQL Server Management Studio (SSMS), Azure Data Factory (ADF), and similar resources, it's generally safe to assume that you're not directly interacting with deprecated APIs. These tools typically use standard connection protocols (like TDS for SQL Server) rather than specific REST APIs that might have deprecated versions.

However, if your ADF pipelines or other resources indirectly interact with Azure services through APIs (e.g., using HTTP-triggered functions or REST API calls), you might want to verify that those interactions aren't using deprecated versions. But for direct database connections using connection strings, deprecated API versions wouldn't be a concern.

I hope this helps.
Uwe Fuchs 140 Reputation points

2024-08-26T23:06:35.7866667+00:00

Please see this similar post https://learn.microsoft.com/en-us/answers/questions/1455624/how-to-identify-usage-of-azure-sql-database-2014-0. You might also consider reaching out to Microsoft directly for further confirmation.
Dan Chan 91 Reputation points

2024-08-27T02:50:30.71+00:00

Hi @Uwe Fuchs ,

Thanks for your responses.

We use Cold Fusion and PowerPlatform (PowerAutomate, PowerApps, PowerBI) to interact with our Azure SQL databases. So, I guess we should be safe.

But, to ensure this API deprecation does not affect us, we should contact Microsoft about it. I will plan to do it.

Thanks.

dchan
Joanne Hatton 0 Reputation points

2024-08-27T08:49:40.0266667+00:00

Hi I received the same error and have the same problem - any clarification would be helpful.

Joanne
Uwe Fuchs 140 Reputation points

2024-08-27T19:43:57.0266667+00:00

@Joanne Hatton can you confirmhow your SQL is configgered (i.e., Azure SQL Database, VM hosted, etc.), and how you are connecting to it?
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-09-25T04:02:52.4366667+00:00

@Dan Chan
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi @Dan Chan

You can open Azure portal -> Subscriptions -> Resource Providers, search for "Microsoft.Sql", if this is registered, you will receive the notification. If there is no SQL resource created in the subscription, you can ignore the notification email

The alert is on the azure advisory refers to an update that is being done on the APIs from azure.

The retirement notice is specifically about the API version used for managing and interacting with Azure SQL Database resources programmatically.

If you are currently using the Azure portal, Azure CLI, or Azure PowerShell to manage Azure SQL Database, you need not to take any action.

Someone has shared HttpIncomingRequests table query. I believe HttpIncomingRequests is a backend query that can be executed by the support agent only.

Below query you can try running in Azure Resource Graph Explorer from Azure portal

resources

| where type == 'Microsoft.Sql/servers/databases'

| project apiVersion

Hope this help!

Share via

How to check if I "Upgrade Azure SQL Database 2014-04-01 APIs" applies to me?

1 answer

Your answer