I attended my first SQL Saturday event two weeks ago at SQL Saturday #47 – Phoenix and it was a day well spent. I was lucky in that the event was held about 7 miles from my house, so I really had no excuse not to go. A drawback of this, however, was that I […]
Today, I embark on a new adventure – I’m starting at a new company. I’ve left a company where I was the sole DBA managing about 15 SQL Servers and going to one where I will be one of two DBAs managing approximately 600 servers. I’m excited about the challenges managing so many servers will […]
I’ll be attending SQL Saturday #47 – Phoenix this Saturday, Feb 19! It’s being held just a few minutes from my house, so I really couldn’t pass it up! This will be my first SQL Saturday event and I am looking forward to it. If you see me, say hi. (I tend to be pretty […]
I ran into a situation with database mirroring today that, at first glance seemed to defy logic. I came into to work to discover some of my mirroring sessions had been paused since last night. That happened because one of my scheduled jobs, which paused mirroring, failed and the “resume mirroring” step never got executed. […]
I had to play detective a bit this week. I get a weekly report that gives me a list of databases that have more than 50 VLFs in their transaction log files. I posted the code that generates it here. My transaction logs are in pretty good shape now and I only occasionally get a […]