Presenting On Basics Is Difficult
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
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
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
12 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
36 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
200 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
8 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
1 reads
I spend a lot of time in the forums on various web sites, trying to assist people with getting help online. It’s shocking how hard they make it. Let’s...
2022-11-02 (first published: 2022-10-24)
134 reads
It’s possible for you to see new technology at work if you use Extended Events to monitor cardinality feedback. To put it simply, cardinality, the number of rows being...
2022-10-26 (first published: 2022-10-17)
218 reads
While Query Store has been out for quite some time now, released in 2016, there’s still quite a lot of missing understanding of what Query Store can do for...
2022-10-11
2 reads
Recently, a person asked about the costs differences in an execution plan, referencing them as if they were performance measures. The key to understanding performance is to check every...
2022-10-10
2 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers