“If it ain’t broke, don’t fix it.” Let’s face it, we all live by that more than we should. We’re busy and it’s the problems people are complaining about that get all our attention. We rarely have the time to go back and improve our routines or redesign them. (Which is one reason I insist […]
I came back into the office after New Years to find roughly 275,000 email messages in my inbox. Yup. Over one quarter million emails. It took over 2 hours to download them all and even longer to delete them. Obviously, something was going on. (Normally, I would have seen these alerts on my work cell […]
After watching Brent Ozar’s webinar on backups and virtual machines, I was inspired to take a deeper look at our company’s overall backup plans. I had already gone through the code that was actually doing the backup, found some crazy stuff, and fixed it, but this time through I wanted to take a closer look […]
It’s been a hectic couple of weeks here. You may remember I started a new job a couple of months ago and I was one of two DBAs. About three weeks ago, the other DBA left and I’ve been climbing a steep learning curve trying to get caught up on all the intricacies of this […]
I’ve written before about some of the bad SQL programming practices I’ve discovered in various programs. I’ve found yet another example that has been causing me grief for a couple of weeks. We’ve got a scheduled job that runs nightly and does some archiving – moving records from a live database to an archive database […]