I will not even attempt to hide it, I’m very much in the learning phase of my PostgreSQL journey. As such, I’m constantly picking up new facts. However, I’m...
2023-02-24
5 reads
I was talking with some developers from my team about monitoring, and I said, “We all use the same tools,” referring to other monitoring software. Then, it hit me....
2023-02-21
7 reads
The question came up that someone wanted to monitor the queries impacting tempdb using Extended Events. Initially, I was pretty sure that there was no real way to do...
2023-02-13
19 reads
Microsoft supplies quite a few knobs to control how Query Store performs data cleanup. You can set your cleanup various ways, and, they interact. Let’s talk about how and...
2023-02-22 (first published: 2023-02-06)
264 reads
Over the last year, at work and after work, I’ve been teaching myself a lot of brand new technologies. As such, I’m reliant on others to have put together...
2023-01-30
8 reads
Very excited to take part in my third #PGSQLPhriday blogging event, even more so because it’s a topic that’s quite near and dear to my heart, community. To say...
2022-12-02
22 reads
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
51 reads
If you’re interested in getting a digital copy, my brand spanking new book is now available here. It’s in the intro, but let me tell you a little bit...
2022-11-11
244 reads
It’s time again for the another PGSQL Phriday, this time, the question has been asked: How do you do PostgreSQL backups? Honesty up front. I’m very much just beginning...
2022-11-04
12 reads
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don’t...
2022-10-31
8 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