@Vanessen Munisamy Thank you for reaching out.
I understand your concern about having to constantly update IP whitelists. To avoid this, you can use Azure Virtual Network (VNet) Service Endpoints. This allows you to securely connect your Azure services to your SQL Database without needing to whitelist IP addresses.
You can enable "Virtual Network service endpoint" for your SQL Database from the Azure Portal on the networking blade.
By enabling VNet Service Endpoints, you can ensure that only resources within your specified Virtual Network can access your SQL Database, without needing to manage IP whitelists.
Please do let us know if you would like more detailed steps or any additional help with this configuration.
Regards,
Oury