The Desert DBA

Online certification exams are definitely different

• by DesertDBA

• The Desert DBA

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...

2020-08-01

32 reads

Online certification exams are definitely different

• by DesertDBA

• The Desert DBA

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...

2020-08-01

How I passed the 70-762 certification exam

• by DesertDBA

• The Desert DBA

According to the myriad of statistics used to track such things, the post “How I passed the 70-761 certification exam” has been one of the most popular on this...

2020-05-31

28 reads

Query Store capture note: All does not mean what you think it means

• by DesertDBA

• The Desert DBA

As many of you know, Query Store is a wonderful tool for identifying query regressions, which in turn makes it an equally wonderful tool for migrations involving an upgrade...

2020-04-30

15 reads

Why can’t I remove this extra transaction log file?

• by DesertDBA

• The Desert DBA

Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...

2020-03-05 (first published: 2020-02-29)

394 reads

Why can’t I remove this extra transaction log file?

• by DesertDBA

• The Desert DBA

Before this post gets started, let’s get past the title. I know what many of you are thinking: what in the name of Paul Randal would make someone have...

2020-02-29

Removing ad hoc plans from Query Store

• by DesertDBA

• The Desert DBA

This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...

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

355 reads

Removing ad hoc plans from Query Store

• by DesertDBA

• The Desert DBA

This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...

2020-02-20

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

• by DesertDBA

• The Desert DBA

Last Friday I spent my lunch break going through some links I had marked for future reading. One of them was a post earlier this month by Erik Darling...

2020-02-13 (first published: 2020-01-28)

1,516 reads

Using Erik Darling’s sp_pressure_detector to resolve CPU issues

• by DesertDBA

• The Desert DBA

Last Friday I spent my lunch break going through some links I had marked for future reading. One of them was a post earlier this month by Erik Darling...

2020-01-28

3 reads