2025-10-22
53 reads
2025-10-22
53 reads
I needed to test a striped backup, so I decided to ask the AI’s for help. This is part of a series of experiments with AI systems. The Problem...
2025-10-22
6 reads
2025-10-20
1,582 reads
Open offices have an interesting side effect: less collaboration.
2025-10-20 (first published: 2018-08-27)
147 reads
It’s been a good year for me. With my sabbatical, I felt like I’ve gotten away from work quite a bit this year. I’ve had a few vacations around...
2025-10-20
13 reads
2025-10-17
1,716 reads
This was one of the original values: The facing page has this text: No matter how smart you are, or how good you are at narrowly defined tasks, there...
2025-10-17
145 reads
I saw an article recently about implicit transactions and coincidentally, I had a friend get caught by this. A quick post to show the impact of this setting. Another...
2025-10-17 (first published: 2025-09-24)
258 reads
Learning is fundamental in technology. Steve has a few thoughts on adopting a new technology at work.
2025-10-17
93 reads
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into an interesting issue. This is part of a series of experiments with AI systems. My...
2025-10-16
123 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...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
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;