SQL

Azure SQL Managed Instance Send Via On Prem SMTP

Recently it was brought to my attention that one of our Azure SQL managed instances was not sending SMTP mail via our on prem SMTP server, with an error suggesting it could not make a network connection. But, surely not… I had checked the outbound NSG rules and on prem firewall rules, in both cases … Read more

Issues Using Differential SQL Backup In Azure VM

I recently came across a problem where a couple of our Azure SQL VMs (Yeah, I know.) were failing their differential backups because of a broken backup chain. The order of backups was as follows: SQL full backup taken Sunday 8pm – Successful SQL differential backup taken Monday 8pm – Successful Azure VM backup taken … Read more