sql-serverazure-sql-databaseazure-bicep

Update Bicep File to Fix Azure SQL Database 2014-04-01 APIs will be retired?

My IT department is getting an e-mail "Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025". I use bicep and have never used any API's that are that old, they're all currently at 2021-11-01. If I export my Azure SQL Database or Server I get entries like the following:

resource servers_myproj_dev1_sql_name_CreateIndex 'Microsoft.Sql/servers/advisors@2014-04-01' = {
  parent: servers_myproj_dev1_sql_name_resource
  name: 'CreateIndex'
  properties: {
    autoExecuteValue: 'Disabled'
  }
}

I believe these were implicitly added when I initially deployed. Two questions:

  1. On November 1 2025 will I experience any problems due to obsolete API's?
  2. How can I stop the e-mail that are unnerving my IT department?

I'm fairly certain from running the Graph queries specified in How to react to message from Microsoft regarding updating API's that the answer to 1 is no, it won't be a problem.

enter image description here

What I don't know about is #2. If I update my bicep files to specify Microsoft.Sql/servers/databases/advisors@2021-11-01 with autoExecuteValue: 'Disabled' will it make the error messages go away?

Solution

  • The message is just general message and does not necessary means you are using Azure SQL Database 2014-04-01 APIs. If you are using the export functionality in Azure Portal that is Azure service and you can log official support case. My guess after the retirement date that will be fixed. You will experience issues only if you are using that API version in your Bicep templates or any automation tool/language that uses that version. There is no way that these e-mails can be stopped. I believe anyone with owner permissions (may be also contributor) is getting e-mails like these that communicate the deprecation of a feature or service. The ARG query that you are running has nothing to do with API versions that you use on your resources. That query shows which version of the resource was used by ARG to show the data for that resource. These notifications are not error messages, they are e-mail notifications so I am not sure exactly what you mean by error messages. If you are facing any error message when applying Bicep template you should post a separate question for that.