No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL Server 2025, those footprints point us straight toward the next big feature: optimized locking. And...
2025-10-15 (first published: 2025-09-24)
1,407 reads
Why you should connect resiliently to SQL Server
Transient failures happen — in the cloud (Azure SQL) and on-prem. A resilient connection strategy lets your app recover gracefully instead of...
2025-10-14 (first published: 2025-10-13)
74 reads
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help that," said the Cat: "we’re all mad here. I’m mad. You’re mad.""How do you know...
2025-10-14 (first published: 2025-10-13)
19 reads
There was a time when the Chief Data Officer lived in the shadows of the enterprise. Their office lights burned late into the night as they combed through spreadsheets...
2025-10-14
12 reads
Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...
2025-10-13 (first published: 2025-09-18)
314 reads
I saw some good reviews of the small gemma3 model in a few places and wanted to try it locally. This If you want to get started, read my...
2025-10-13
25 reads
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The attic was called the data warehouse, and while it...
2025-10-13 (first published: 2025-10-09)
80 reads
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily create database snapshots. This new version fixes a bug that we’ve found in version 2...
2025-10-13 (first published: 2025-10-02)
32 reads
In parts 1 and 2 of this series, we’ve gathered info and done the triage just like anyone in almost any industry does At this point you’ve: Defined what...
2025-10-13 (first published: 2025-10-01)
258 reads
Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents...
2025-10-13 (first published: 2025-09-18)
460 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;