The Desert DBA

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

52 reads

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

51 reads

How I applied 13 cumulative updates in 12 minutes

• by DesertDBA

• The Desert DBA

Twitter is a strange place. I mean, aside from all the outrage practice and animal videos. Last week I sent out a tweet about how I used dbatools to...

2019-10-09 (first published: 2019-10-04)

683 reads

Find and fix that troublesome Windows Power setting

• by DesertDBA

• The Desert DBA

For the most part, the default configurations for SQL Server are pretty good. Yeah, there are a few you should definitely change (like say, the ones involving parallelism), but...

2019-08-30

1 reads

For those who want to be a Junior DBA

• by DesertDBA

• The Desert DBA

I’ve been fortunate to have spoken at a few SQL Saturday events this year, and one of the sessions I’ve had the pleasure of presenting has been about getting...

2019-08-01

1 reads

So, my first SQL Saturday presentation had some issues

• by DesertDBA

• The Desert DBA

It’s been a while since I’ve had a new post here, and that’s largely due to the quantity of other things on which I’ve been working. This list of...

2019-04-19

Central Management Server – not just three boring words

• by DesertDBA

• The Desert DBA

Maybe more people would use the Central Management Server feature of Management Studio if it had a name that didn’t sound as utilitarian as a heat pump. Something like...

2019-01-28

2 reads

Failovers can’t serve two masters

• by DesertDBA

• The Desert DBA

As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...

2018-12-02

PASS Summit 2018 brain dump

• by DesertDBA

• The Desert DBA

Much like your paycheck, this post is two weeks after the fact. But also like your paycheck, it’s got a good deal of personal importance. I’ve taken a couple...

2018-11-25

Don’t believe the myth TRUNCATE TABLE isn’t logged

• by DesertDBA

• The Desert DBA

Remember the Bill Gates email hoax? The one that claims to be some sort of Microsoft beta test saying Gates is going to pay cash money to anyone who...

2018-10-05