If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered requires SQL Server to participate in the snapshot: the write IO freeze, the metadata backup,...
2026-05-25 (first published: 2026-05-08)
101 reads
I’ve been thinking a lot lately about what it actually takes to make an AI agent genuinely useful for database work, both for administration and for application access to...
2026-05-24
41 reads
If you’ve been following my T-SQL Snapshot Backup series, you’ve seen this technique work on bare-metal and standard VM deployments where database files live on volumes directly presented to...
2026-05-18 (first published: 2026-05-08)
20 reads
I’ve been doing storage load tests for SQL Server for a long time, both as a consultant and now in my work at Everpure, and I see the same...
2026-05-11 (first published: 2026-04-27)
204 reads
Are you considering replatforming your SQL Server workload due to recent vendor changes, but still need high availability and disaster recovery? You’re not alone. One of the challenges with...
2026-04-22 (first published: 2026-04-12)
227 reads
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned and unplanned failovers. The easy case is a planned failover, where you deliberately move the...
2026-04-20 (first published: 2026-04-19)
40 reads
In my planned failover walkthrough, I showed what happens when you deliberately move the primary role to another replica. That’s the easy case. Now I want to show what...
2026-04-19
6 reads
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one of my favorite rabbit holes is revisiting Paul Randal’s series on file header pages. If...
2026-04-18
41 reads
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now runs successfully on Docker Desktop for macOS without needing OrbStack.
2026-02-11 (first published: 2026-02-02)
128 reads
End-to-end NVMe vs PVSCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and DiskSpd results and analysis.
2026-01-21 (first published: 2026-01-07)
272 reads
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
By Vinay Thakur
Google has contributed a lot of stuff/enhancement on its portfolio, google is no longer...
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
Comments posted to this topic are about the item No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers