If my bicep code only deploys the resource Azure SQL server do I have to update anything as automatically included resources of type Microsoft.Sql/servers/advisors@2014-04-01 will retire?

Question

We are deploying an azure sql server via bicep template. Our bicep file only includes the resource

Microsoft.Sql/servers@2023-05-01-preview. If you take a closer look at the resources exported arm template within the azure portal you will notice child resources of type Microsoft.Sql/servers/advisors with an api version 2014-04-01. According to azure this version of the advisors will retire in Octobre 2025. As our bicep file doesn't mention resources with this provider explicitly but they are apparently part of the same deployment we don't know whether we have to update anything in our bicep file in order to avoid any incompatibilities.

Answer 1

Hi @Admin Florian, Giebel

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

We would like to inform you that, customers who have registered for Microsoft.SQL will receive these notifications. To avoid any potential issues, you should update your Bicep template to use a newer API version.

You will need to update your resources, including templates, tools, scripts, and programs, to use a newer API version by then. Any API calls still using the older versions after that date will stop working until you have updated them.

To avoid any incompatibilities, you should update your Bicep template to explicitly include the Microsoft.Sql/servers/advisors resource with a newer API version. You can find the latest API versions and their properties in the Azure documentation https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/servers/advisors?pivots=deployment-language-bicep and https://learn.microsoft.com/en-us/azure/templates/microsoft.sql/servers?pivots=deployment-language-bicep

Deploy the updated Bicep template in a test environment to ensure everything works as expected.

There will be coming up more details on this retirement in the next few weeks https://learn.microsoft.com/en-us/rest/api/sql/retirement

I hope, This response will address your query and helped you to overcome on your challenges.

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.