We have an azure virtual network with a web role, worker role and a dedicated sql VM. Currently we're using the VM dns name in the database connection string. I was thinking it would be better to update the connection string to use the private ip address to skip the name resolution, mydbserver.cloudapp.net to 10.0.0.1.
Since all virtual machines have to use DHCP is there a chance the private ip will change? If so is there anyway to address this? Thanks