Preserving Data
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
2026-08-31
244 reads
Backup and restore
How a SQL Server backup can execute attacker code during restore
CVE-2026-47295 is a SQL Server vulnerability that lets a maliciously crafted database backup execute attacker-controlled code with sysadmin privileges during a routine RESTORE DATABASE operation.
2026-08-24
2026-08-07
882 reads
2026-03-16
907 reads
2026-03-09
975 reads
2026-03-04 (first published: 2026-03-02)
1,079 reads
2026-02-16
724 reads
SQL Server 2025 Backup Compression Algorithm
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
2,533 reads
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.
2025-12-17
943 reads
2025-10-27
1,192 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers