Optimized Locking in SQL Server 2025
Learn about Optimized Locking in the latest versions of SQL Server and Azure SQL Database.
2026-10-02
2,355 reads
Articles
How to mirror data from SQL Server to Microsoft Fabric: complete guide
Learn all about Microsoft Fabric mirroring for SQL Server: how it works, what's new in 2025, setup, limitations, and troubleshooting
2026-10-02
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
2026-10-02 (first published: 2026-09-28)
Database Animations: Stop Using Page Splits to Justify Lowering Fill Factor.
You're looking at page split numbers in a monitoring tool or Perfmon, and you've heard that page splits are bad, so you're lowering fill factor, expecting your page splits to go down.
2026-09-30
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
This article looks at how the parameter sniffing performance problem can be helped in SQL Server 2025 with PSPO.
2026-09-28
2,414 reads
Why SQL Server’s default trigger execution model is a security flaw – and what Microsoft should do about it
The situation raises a question I’ve been thinking for a while: why does SQL Server allow trigger code to inherit the privileges of whichever principal happens to fire it?
2026-09-28
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Diagnosing memory issues can be hard. This article shows how one administrator used custom tracking to determine whether SQL Server, SSAS, or SSRS was the issue.
2026-09-25
2,030 reads
Migrate SQL Server Databases to Different Active Directory Domain
We want to leverage Distributed Availability Groups to migrate our databases to a different Active Directory domain. How do we go about it?
2026-09-25
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Reproduce traditional row-lock accumulation and writer blocking, then see how SQL Server 2025 uses transaction ID locking and Lock After Qualification to improve concurrency—and where hints, isolation levels, and query shapes limit the benefit.
2026-09-23
2,707 reads
Database Animations: The Interview Question Everybody Gets Wrong
No no, I'm not just talking about the people answering the interview question. I'm talking about the people asking the question.
2026-09-23
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers