Backup to Immutable Storage

SQL Server 2025 Backup Compression Algorithm

Learn about the new ZSTD compression algorithm in SQL Server 2025.

Stairway to Azure SQL Hyperscale Level 6: Backup and Restore Internals

Learn how backup and restore work in Azure SQL Hyperscale in this next level in the stairway series.

Striped Backup File Limits

Recovering data in SQL Server without full backup

There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.

Deleting a Database

Who among us hasn't deleted a production data file? Steve hopes most of us have not.

The Backup Space Needed

The Table Backup

Partial Backups II

SQL Server Backup or Restore using Network Share with SSMS

In this article, we look at how to create a SQL backup to network share or restore a backup from a network share.