Check multiple databases quickly If you work or have worked, in a shop with lots of SQL servers then you either have, or will, experience an issue with storage. Like for instance, you’re storage c...

Training is important Earlier in the year, I set out with aspirations of doing a better job blogging and keeping up with training. At least on a personal level.  I admit I slid a touch on my we...

Kill the SPIDs Recently came across a situation where reporting logins were interfering with nightly jobs due to blocking. After a number of attempts of trying to resolve the blocking, it was deci...

SQL Saturday Colorado Springs (SQLSat #584) It’s been a while since I’ve attended a SQL Saturday. I think the last one was in 2013 in OKC, to be exact. I had blogged about that one too, but I th...

Procedure vs Technique One of the things I do when I workout, or drive alone, is to listen to podcasts. One of the podcasts I subscribe to is the Art of Charm, which describes itself as providing ...

It’s amazing how time seems to fly, especially between blog posts. I’ve known I needed to post a blog for a while; I’ve even thought of a few different topics. Alas, the execution has not been go...

Relationships Matter I have had a long career in the IT area and I have met all kinds of people during that time. My interest in computers grew out of a hobby and gaming. By constantly fixing, upg...

Tempdb A while back I was working on setting up a new Availability Group (AG), which required working with tempdb. It was a bit of an advanced setup in the sense that it was a five node cluster, f...