Driving my soon-to-be granddaughter to school today (my son is getting married and will adopt the young lady), we saw a dead armadillo, a turtle in the road (rescued it) and an escaped cow (left it alone). THEN... old soon-to-be granddad had forgotten lunch, so had to deliver that back at the school (cow must […]
2025-04-26
66 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
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 won't even try to hide it. I got a huge kick out of the penguin characters in the animated movie, Madagascar. For those who don't know, they're trying to escape the zoo, but are trying to hide that from anyone discovering it. So, they put up a front, "Smile and wave boys. Smile and […]
2025-03-22
84 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’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 just saw one of "those" questions. You know the ones: 'We're hitting an error with a stored procedure. What is the maximum number of parameters you can have?" <sigh> Look, I get it. Breaking the land speed record is cool. Getting the most people into a phone booth (look it up), also cool. Fastest, […]
2025-02-15
123 reads
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
2025-01-11
66 reads
Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal. Well, until I […]
2024-12-14
104 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
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...
I've come across what appears to be a strange deadlock anomaly. As seen in...
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Comments posted to this topic are about the item The Challenge of AI, which...
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers