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)
338 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
133 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
72 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
110 reads
Last week the 2024 PASS Data Community Summit conference was held in Seattle. 1,700 of my closest friends got together for a week of learning (well, technically it's a three day conference, but there are two days of pre-conference seminars) and sharing. I'm still exhausted a week later (although, old age and an aggressive travel […]
2024-11-16
119 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)
267 reads
Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]
2024-10-19
280 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)
273 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)
384 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)
143 reads
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers