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)

565 reads

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

16 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

55 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

1 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

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)

286 reads

I Read Quite a Bit

• by Grant Fritchey

• SQLServerCentral

• learning

Today Grant talks about the challenges of sometimes finding good, current information.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

2020-06-15

102 reads

• Discuss

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

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