Optimized Locking in SQL Server 2025
Learn about Optimized Locking in the latest versions of SQL Server and Azure SQL Database.
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
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
This final level focuses on the practical application of changesets in complex scenarios. From table transformations to ETL-driven logic, it explores how to manage database changes when rollback is no longer purely structural, emphasizing control, predictability, and pragmatic solutions.
You Need a DBA Pipeline
Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.
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.
Designing for Teams
When we build software, or we put together a process, we need to consider how teams use it, not just individuals.
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.
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?
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
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...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers