We have an azure sql server exposed by private link to a linux virtual machine in peered vnet. We installed an azure pipeline agent on it, to be able to deploy items to the private network.