I think I’m actually going to make this TSQL Tuesday, it’s the first for me in a while. I kind of have a valid excuse, I left my job at the hospital in Denver and took a job in Duluth, MN. So cur...
New Opportunity Up North
Leaving DHHA It’s hard to believe this is my last week in Denver. Come Monday I am moving to northern Wisconsin. I’m jumping in the truck alone to head for the Great Lake region with my wife follo...
SQL Saturday 673
I feel accomplished a bit this year, I’ve made it to two SQLSaturdays in the same calendar year. This SQLSaturday was put on by the Denver SQL Users group and was hosted at the University of Denv...
Group By - SSMS Shortcuts
Every so often, you come across game-changing information and most of the time, this type of information costs money. So it is EXTREMELY rare to come across this type of information for free. With ...
Microsoft Embraces Linux
Update: Microsoft admits being wrong on Linux **Hell is actually freezing over…. Having been in the IT industry for a while, I’ve learned a few things. One of those so-called things is, Microso...
Check for Corruption
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...
Keeping up with training
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...
Disable login & Kill SPIDS
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 584
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
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 ...