The Scary DBA

Extended Events Capturing the T-SQL of Prepared Statements

• by Grant Fritchey

• The Scary DBA

I asked this question myself: Is there a way to use Extended Events to capture the T-SQL of a prepared statement? Why would I be concerned with prepared statements?...

2020-07-06

3 reads

SQL Server Backups on AWS RDS

• by Grant Fritchey

• The Scary DBA

One of the things I love the most about Platform as a Service offerings is the fact that it makes it so I don’t have to do silly things...

2020-06-29

50 reads

State of Database Monitoring

• by Grant Fritchey

• The Scary DBA

Redgate published a report that many of you helped with by providing information. First, thanks! Your info really helped. Second, do you want to see it? You can. Go...

2020-06-22

Database Fundamentals #26: The Primary Key War

• by Grant Fritchey

• The Scary DBA

There is a war about primary keys in the database world. There are two camps. The first camp believes that primary keys should only ever be created on meaningful...

2020-07-06 (first published: 2020-06-22)

435 reads

Combining DMVs, Query Store and Extended Events Is Challenging

• by Grant Fritchey

• The Scary DBA

I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance. Moreover, they were frustrated...

2020-06-18

AWS RDS and SQL Server Deadlocks

• by Grant Fritchey

• The Scary DBA

What’s the story with AWS RDS and SQL Server deadlocks? I’m approaching AWS RDS like I was taking on a new role at a new organization. Do we have...

2020-06-08

13 reads

Fun Fact: AWS RDS and system_health

• by Grant Fritchey

• The Scary DBA

Did you know that the system_health Extended Event session was running in your RDS instances? Well, it is. HOWEVER. This query, which works perfectly fine on my on premises...

2020-06-02

9 reads

Getting Started on AWS RDS

• by Grant Fritchey

• The Scary DBA

I’m expanding my skill set into AWS in a big way. So, one of the things I do when I’m learning a technology is to write blog posts about...

2020-06-17 (first published: 2020-06-01)

281 reads

Let’s Talk About The Cloud

• by Grant Fritchey

• The Scary DBA

I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for short). It’s going to a panel discussion lead by experts on cloud technologies. I’ll be...

2020-05-29

12 reads

Database Fundamentals #25: Referential Integrity

• by Grant Fritchey

• The Scary DBA

If you have been reading through all my fundamentals posts and following along, you have built a small sample database, loaded it with data, and learned how to retrieve...

2020-06-10 (first published: 2020-05-26)

275 reads