Did Not Know That - Redirecting CMD to the Clipboard

One of the items I frequently deal with as a Production DBA is drive alarms.  I have written previously about...

The Mystery of the Exploding T-Log

There were a stack of errors overnight in the DB123 database on SQL01, including one horror show error:
--
Log Name:      ApplicationSource:        MSSQLSERVERDate:          5/24/2018...

Speaking This Weekend in Iowa City!

Come out to SQL Saturday Iowa at the University of Iowa this Saturday 06/23/2018 for a SQL Saturday that never...

Revoke the permission(s) before dropping the server principal

As a remote DBA I often have to log in to client systems for a fixed amount of time and...

Double Win- Watch DeWitt and Help SQLSoldier's Loved Ones!

Brent Ozar (blog/@BrentO) is sponsoring a special webcast in a couple weeks, with an amazing presenter:

https://www.brentozar.com/archive/2018/06/announcing-a-very-special-sqlfamily-webcast-with-dr-david-dewitt/
The webcast (“SQL Query Optimization....

Speaking at PASS Summit 2018!

I found out a few days ago that one of my sessions was selected for Summit this Fall - I will...

Toolbox - How Long Has My Server Been Up?

https://imgflip.com/i/2axp6yNo..not that Up (although it is awesome!)

--

As a remote service provider a common request is to follow up after a server...

When Good Query Plans Go Bad

Today's story starts again with a page escalation:

--
We are seeing very high CPU usage on DistServer01.  Could you please take...

Why Don't I have a Preferred Replica?

The client reported that the log file on their main database was growing unusually large, and when they checked the...

Toolbox - Do You Have Current Backups?

On our managed servers we run a job each day to check that either a FULL or DIFF has run...