I have a Azure managed instance that has a host name as yourdb.<DNS-ZONE>.database.windows.net . I Whenever this managed instance is newly created I have to update this host name in every connection string.
Is there a way which allows to have a static FQDN for managed instance?
To use the custom DNS, Azure SQL Managed Instance must be deployed within an Azure virtual network (VNet). Check Configure a custom DNS for Azure SQL Managed Instance.
Also, check the scenarios which is suitable for FQDN in the following link.