The Scary DBA

Extended Events Misperceptions: Profiler is Easier

• by Grant Fritchey

• The Scary DBA

I know, I know, I’m on #teamexevents so I think that Extended Events can do no wrong, but let’s address this thought that Profiler is easier. Now, if we’re...

2020-01-20

Causality Tracking in Extended Events

• by Grant Fritchey

• The Scary DBA

If you go through all the stuff I’ve written about Extended Events, you’ll find that I use causality tracking quite a bit. However, I’ve never just talked about what...

2020-01-13

24 reads

Execution Plans: First Operator

• by Grant Fritchey

• The Scary DBA

The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...

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

461 reads

Ending My Time as PASS President

• by Grant Fritchey

• The Scary DBA

With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....

2020-01-10 (first published: 2019-12-30)

416 reads

Fritchey Family Christmas Movies

• by Grant Fritchey

• The Scary DBA

MERRY CHRISTMAS! HAPPY YULETIDE! HAPPY HANUKKUH! Instead of something technical, let’s take a moment to just kick back and enjoy a few great Christmas movies. Now, let’s be clear....

2019-12-23

9 reads

Why Don’t People Use Columnstore Indexes?

• by Grant Fritchey

• The Scary DBA

I saw this question on SQL Server Central the other day and had an immediate, visceral reaction. I know why. Now, before I explain my answer, please, let me...

2020-01-01 (first published: 2019-12-16)

1,280 reads

Distributing Jupyter Notebooks

• by Grant Fritchey

• The Scary DBA

If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...

2019-12-18 (first published: 2019-12-09)

312 reads

State of Database DevOps Survey

• by Grant Fritchey

• The Scary DBA

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....

2019-12-06

41 reads

Tracking CPU Use Over Time

• by Grant Fritchey

• The Scary DBA

A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...

2019-12-16 (first published: 2019-12-02)

615 reads

Containers: Upgrading SQL Server from 2017 to 2019 RTM

• by Grant Fritchey

• The Scary DBA

Throughout the pre-release of SQL Server 2019, I was demoing an effectively instant, and magical, container upgrade from 2017 to 2019. However, when I finally downloaded the release bits...

2019-12-05 (first published: 2019-11-25)

261 reads