Backing up a damaged database

Restoring a Certificate

Long Term Storage

Long term data storage isn't something we always need for databases, but it is something the world needs. A new technology has promise for those use cases, both in durability and preserving the algorithms needed.

Azure SQL Database Differential Backup Frequency

Full Azure SQL Database Backup Frequency

Azure SQL Database Backups

Scripting Makes Mistakes Easier Than Ever

A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.

Backup Architecture

Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.

Managed Instance Backups

Preventing Changes After the Tail-Log Backup