The Scary DBA

Validating Backups: PGSQL Phriday #002

• by Grant Fritchey

• The Scary DBA

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

1 reads

Weaponizing Query Store

• by Grant Fritchey

• The Scary DBA

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

Getting Help Online

• by Grant Fritchey

• The Scary DBA

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-10-24

Monitor Cardinality Feedback in SQL Server 2022

• by Grant Fritchey

• The Scary DBA

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-17

Query Store at PASS Data Community Summit

• by Grant Fritchey

• The Scary DBA

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

Check Every Metric

• by Grant Fritchey

• The Scary DBA

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

PGSQL Phriday #001: Two Truths and a Lie

• by Grant Fritchey

• The Scary DBA

As a part of my own journey of learning within PostgreSQL, I’ve decided that I’m going to take part in PGSQL Phriday as often as I can, just as...

2022-10-07

DevOps From Redgate

• by Grant Fritchey

• The Scary DBA

In a few weeks at the PASS Data Community Summit, I’ll be joining several other Redgaters to put on an all-day precon where we take you on a database...

2022-10-04

Function Vs. Performance

• by Grant Fritchey

• The Scary DBA

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that I decided to answer. I went off, set up a test database and some test...

2022-10-03

Why You Need Presentation Skills

• by Grant Fritchey

• The Scary DBA

And no, the answer is not because you want to be a Microsoft MVP. Multiple surveys have been published over the decades that list “fear of public speaking” as...

2022-09-29