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)
29 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
35 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)
192 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)
119 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)
267 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you might have hit a wall trying to get it running. Here’s what happened when I...
2025-12-15 (first published: 2025-11-26)
962 reads
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage FlashArrays, achieving truly consistent backups becomes a critical and interesting technical challenge. In this post,...
2025-11-23
23 reads
In my previous post, I showed you how to build a snapshot backup catalog using SQL Server 2025’s new native REST API integration. But what if you’re still running...
2025-11-12 (first published: 2025-10-25)
298 reads
Update for SQL Server 2025:
This post and the GitHub repo have been updated for SQL Server 2025 RC1 and Ubuntu 24.04.
New in SQL Server 2025: You no longer need...
2025-10-27 (first published: 2025-09-29)
394 reads
SQL Server 2025 introduces native support for vector data types and external AI models. This opens up new scenarios for semantic search and AI-driven experiences directly in the database....
2025-10-20 (first published: 2025-09-27)
1,456 reads
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
Comments posted to this topic are about the item Introducing the Relational Embedding Retrieval...
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers