The Scary DBA

Missing #SQLFamily? Check This Out.

• by Grant Fritchey

• The Scary DBA

I am an introvert. Lots of people don’t believe it, but it’s true. However, I really do love getting to see my #SQLFamily all over the world in my...

2020-03-19

13 reads

Extended Events: Live Data Explorer, Getting Started

• by Grant Fritchey

• The Scary DBA

One reason a lot of people don’t like Extended Events is because the output is in XML. Let’s face it, XML is a pain in the bottom. However, there...

2020-03-24 (first published: 2020-03-16)

248 reads

Extended Events: system_health and a Long Running Query

• by Grant Fritchey

• The Scary DBA

Wouldn’t it be great to just quickly and easily take a look at your system to see if you had any queries that ran for a long time, but,...

2020-03-16 (first published: 2020-03-09)

556 reads

A Rose By Any Other Name

• by Grant Fritchey

• The Scary DBA

There is only one kind of execution plan within SQL Server. I’ve said this several times on this blog. Now, I’d like you to go and read this excellent...

2020-03-11 (first published: 2020-03-03)

325 reads

Query Store, Plan Forcing, and DROP/CREATE

• by Grant Fritchey

• The Scary DBA

I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality. I just...

2020-03-09 (first published: 2020-03-02)

404 reads

Are You Still Worried About Data in the Cloud?

• by Grant Fritchey

• The Scary DBA

There really are technology stacks and business use cases that should never be moved off of big iron. Then there’s the rest of us. Chances are very high if...

2020-03-03 (first published: 2020-02-27)

553 reads

Redgate Software Needs You!

• by Grant Fritchey

• The Scary DBA

I’ve been very blessed to be able to work for Redgate Software. We’ve done some amazing stuff over the years. We’re going to be doing even more amazing stuff...

2020-02-24

26 reads

Extended Events: Database Auditing

• by Grant Fritchey

• The Scary DBA

Extended Events can do things that simply are not possible with Profiler and another example comes from the stack of audit events that exist only in Extended Events. One...

2020-02-24

54 reads

Why I Support Code Automation Tools Like ORMs

• by Grant Fritchey

• The Scary DBA

I know I’m a weirdo. I’ve always been a weirdo. When I was a DBA (now I only play one on TV), I was a weirdo too. Case in...

2020-02-25 (first published: 2020-02-17)

535 reads

Be Kind

• by Grant Fritchey

• The Scary DBA

Simply put, we are not always going to agree. Please, take this as someone who was nicknamed “The Scary DBA” for reasons comic and tragic. I’ve screwed up a...

2020-02-18 (first published: 2020-02-11)

473 reads