The Desert DBA

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

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

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

346 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,500 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

How I passed the 70-761 certification exam

• by DesertDBA

• The Desert DBA

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...

2020-01-24 (first published: 2020-01-18)

1,077 reads

How I passed the 70-761 certification exam

• by DesertDBA

• The Desert DBA

FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...

2020-01-18

T-SQL Tuesday #119 – Changing My Mind

• by DesertDBA

• The Desert DBA

This post is for the most recent #tsql2sday, a monthly exercise where a topic is proposed by a community member and everyone is invited to post their thoughts on...

2019-10-08

52 reads