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.
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
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?
Absolute and Relative References
One of the challenges in digital systems involves how we reference other resources. Steve discusses whether absolute or relative references are better.
Get Along
Steve chats with a few developers and gets some insights into how they are coping with AI.
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.
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?
Finely Tuned Models
A company trains a custom model on their own data for $40mm. Is this something that other companies might try at smaller scales?
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.
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers