A Day in the Life (1/?) - August 7, 2018

This is my first installment in (I hope) a series responding to Steve Jones’s (blog|twitter) #SQLCareer challenge. I decided to jot down most of what I did through the...

Are your backup files where they say they are?

 
I was having a cleanup of some old scripts the other day when I stumbled upon a script I wrote...

Azure Training in London

I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...

Flipping Sides in SQL Operations Studio

I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...

MVP for Another Year

I am a little late in posting this, but I still wanted to share. It is a huge honor to...

NTFS Compression and SQL Server Do Not Play Well Together

Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.

What I didn’t realize...

NTFS Compression and SQL Server Do Not Play Well Together

Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.
What I didn’t realize...

Putting Object Explorer etc on the right side of SSMS rather than the left.

A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....

Tracking Down tempdb usage

Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues.  Luckily SQL...

Why you should not use SELECT *

A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...