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)

304 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

103 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)

279 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

23 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

13 reads

Can We Get Row Counts After Execution?

• by Grant Fritchey

• The Scary DBA

The general idea for this question came from dba.stackexchange.com: could we, and if we can, how, get row counts after execution. I was intrigued with the idea, so I...

2020-06-01 (first published: 2020-05-18)

564 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

Find Indexes Used In Query Store

• by Grant Fritchey

• The Scary DBA

One of the most frequent questions you’ll hear online is how to determine if a particular index is in use. There is no perfect answer to this question. You...

2020-05-25 (first published: 2020-05-11)

300 reads

How Does The CHOOSE Command Affect Performance?

• by Grant Fritchey

• The Scary DBA

Questions absolutely drive my blog content and I really liked this one: how does the T-SQL CHOOSE command affect performance. On the face of it, I honestly don’t think...

2020-05-11 (first published: 2020-04-27)

614 reads