2026-03-16
877 reads
Backup and restore
2026-03-09
950 reads
2026-03-04 (first published: 2026-03-02)
1,055 reads
2026-02-16
693 reads
SQL Server 2025 Backup Compression Algorithm
Learn about the new ZSTD compression algorithm in SQL Server 2025.
2025-12-29
2,264 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
835 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)
212 reads
2025-03-28
1,150 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers