2026-03-16
873 reads
Backup and restore
2026-03-09
948 reads
2026-03-04 (first published: 2026-03-02)
1,055 reads
2026-02-16
692 reads
SQL Server 2025 Backup Compression Algorithm
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
2,196 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
821 reads
2025-10-27
1,178 reads
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.
2025-06-23
Deleting a Database
Who among us hasn't deleted a production data file? Steve hopes most of us have not.
2025-05-30 (first published: 2025-05-12)
208 reads
2025-03-28
1,146 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Rantai Mulia Kencana Telpon/WA:08218168291
BCA KCP Rantai Mulia Kencana Telpon/WA:08218168291.Jl. Pesanggrahan Jl. Puri Kencana No.28 29, Kembangan Sel.,...
BCA KCP Pulogadung,Telp/Wa 08213111159
Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
BCA KCP Samanhudi. Tlp:085373737845
Jl. Samanhudi No.57 B, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers