I’m sure I’ve never mentioned that I’m an amateur radio operator. Like Vegans and Cross Fitters, we tend to be shy and withdrawn about our predilections. BWA-HA-HA! Ok, like...
2025-04-28 (first published: 2025-04-11)
353 reads
A while back I wrote about using AI to explore why people are not using Extended Events. You can read all about it here, but a short summary of...
2025-04-11 (first published: 2025-03-31)
294 reads
Let’s face it, most of the time, you probably don’t want your SQL Server execution plans to go parallel. After all, that’s why, instead of adjusting the Cost Threshold...
2025-04-04 (first published: 2025-03-24)
587 reads
When Covid took out the PASS organization, I had someone say to me, “Well, that’s the end of the data community.” My response was pretty simple, “Nope. The community...
2025-03-20
16 reads
I live for questions and this was an interesting one. Can you see Table Valued Parameters that have been passed in to Extended Events? I literally have no idea....
2025-04-02 (first published: 2025-03-17)
308 reads
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute Beginner.” There are several ways to get an understanding of how well your queries are...
2025-02-21 (first published: 2025-02-13)
326 reads
I travel quite a lot for work. Most of it is in the US and Europe, but I get around to other places as well. Most of the time,...
2024-10-21 (first published: 2024-10-07)
266 reads
Please, let me reiterate: The only valid test of a backup is a restore. THE ONLY VALID TEST OF A BACKUP IS A RESTORE. I’m happy that you have...
2024-10-16 (first published: 2024-09-30)
263 reads
Another discussion in Gothenburg (such a great group of people) around Extended Events lead to a (admittedly, tiny) idea for an additional use for sp_statement_completed. The basics for sp_statement_completed...
2024-10-09 (first published: 2024-09-23)
374 reads
I had an excellent group of people in Gothenburg Sweden when I taught there and I was asked: Can You See Who Forced a Plan? I didn’t know the...
2024-09-25 (first published: 2024-09-16)
129 reads
By John
One of the more frustrating aspects about creating an Azure virtual machine is that...
By Steve Jones
Redgate Monitor has been able to monitor replication for a long term, but it...
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Comments posted to this topic are about the item Think LSNs Are Unique? Think...
Comments posted to this topic are about the item The AI Bubble and the...
In SQL Server 2025, how many columns can be included in a Primary Key constraint?
See possible answers