SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some help troubleshooting a SQL connection issue. He had an application server that could not connect to one of our SQL Servers. [Read More]
So I have a new home! Welcome to cjsommer.com part deux!
Just wanted to put a quick post out there for the people who follow me. I very recently made a switch from Wordpress to Jekyll blogging platform and I am certain it will come with a few hiccups. At the moment I don’t have comments enabled, although I hope to... [Read More]
How the SQL Agent Job schedule_uid broke my heart, and my jobs!
This is something that has caused me some grief in my life as a DBA. I hesitate to call it a bug, but this little gottcha resurfaced in a change that was submitted by a teammate just today. So I wanted to share while it was fresh in my mind.... [Read More]
T-SQL Tuesday 85 - Backup & Recovery
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here is a snippet from the invite: Backups are one of the most common things DBAs discuss, and they are at once one of the simplest and most complicated parts of... [Read More]