The Scary DBA

Query Tuning At PASS Data Community Summit

• by Grant Fritchey

• The Scary DBA

The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I’m shortly going to be publishing a 100% rewritten book on query tuning, I...

2022-09-28

Extended Events for Anything but Query Tuning: bulk_insert_usage

• by Grant Fritchey

• The Scary DBA

Wouldn’t it be great to be able to directly monitor specific behaviors within SQL Server, like, oh, I don’t know, knowing exactly when, and how, someone is using BULK...

2022-09-19

1 reads

Look Into Chocolatey

• by Grant Fritchey

• The Scary DBA

Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...

2022-09-12

Database Fundamentals #33: Check Constraints from the GUI

• by Grant Fritchey

• The Scary DBA

The other types of constraints are referred to as check constraints. They limit the data by defining a logical operation that checks the state of the data prior to...

2022-09-05

AWS RDS Restore To A Point In Time

• by Grant Fritchey

• The Scary DBA

The single most important part of backups are not backups. The single most important part of backups are restores. It doesn’t matter a lick if you have 100, flawless...

2022-08-29

AWS RDS Backups

• by Grant Fritchey

• The Scary DBA

One of the things I love the most about Platform as a Service when it comes to data is the fact that you get RDS backups, built in. Go...

2022-08-22

Distributed Replay: The Little Engine That Almost Could

• by Grant Fritchey

• The Scary DBA

Honestly, sincerely, no kidding, I love Distributed Replay. Yes, I get it. Proof positive I’m an idiot. As we needed proof. To be a little fair to me, I...

2022-08-15

Extended Events for Anything but Query Tuning: Object Changes

• by Grant Fritchey

• The Scary DBA

I hear this one all the time: How do I find out who implemented object changes? I also get: Can I see the query that caused object changes? Let’s...

2022-08-08

Thank You Andy!

• by Grant Fritchey

• The Scary DBA

I remember going into Andy Leonard’s session at PASS Summit in Denver. I’m not going to lie, it was kind of sparsely attended, so I got to sit up...

2022-08-02

Learning PostgreSQL: The Tools

• by Grant Fritchey

• The Scary DBA

In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...

2022-08-01