SQL Detective: A Curious Tale of Long Waits
PAGEIOLATCH_SH doesn’t always necessarily mean you have disk problems. Try to get a look at what’s going on in your system as a whole. … More SQL Detective: A Curious Tale of Long Waits
PAGEIOLATCH_SH doesn’t always necessarily mean you have disk problems. Try to get a look at what’s going on in your system as a whole. … More SQL Detective: A Curious Tale of Long Waits
We all make mistakes.. senior / lead DBAs are *gasp* human too! … More Caffeine and Where Clauses: Both Extremely Important
Care for a database related horror story? Well, it’s more of a WTF moment. … More Temporary Insanity
Day 1: Today I was bestowed the honor of writing a data transformation diagram for our current major conversion project to ensure we don’t miss any of the legacy data and have a place for everything in the new system. Apparently the diagrams I’ve written in the past have been deemed “useful”. Sweet! This new … More Musings of a Database Conversion Scribe
If you’re like me and tend to feel embarrassed by the old technology you’re running, don’t be. Instead, hold your head up high. You’re probably doing the best you can with what you’re given and for your specific environment. Some things are out of our control. We can only do our best to get where we need to be. … More Hello! My Name is Rebecca. Yes, We Still Run SQL Server 2000
The First SQL A parody of the song “The First Noel”. Merry Christmas, Happy Holidays, and so on and so forth…! The first SQL the server did say Could not parse this statement please write it this way. In code where it lay a scanning the heap On a production server I wanted to weep. … More Happy Holidays: The First SQL
Yep! Another one! This is another one of those dratted fun and exciting posts inspired by a co-worker planting a little seed in my brain many months ago. It was fun to write and took a long time. I had no idea the song was THAT long! *sigh* Sadly (depending on your point of view), I have another one … More Can’t Group This
Ever have one of those days when you’re working with a colleague on a database issue and one of you has a fun idea that just takes on a life of it’s own? Well, that’s exactly what happened today while we were doing some actual work. Imagine that! Below is what we came up with for … More SQL Woes from A to Z
These are the hysterical ramblings of a frustrated DBA. Her relentless mission: to upgrade strange old systems, to seek out new projects and bad design specs, to boldly index where no one has indexed before. The Incident at Carmulus DBA’s Log, SELECT GETDATE() as ‘Star Date’. After many weeks of deliberation and preparation, tomorrow marks … More Backups – The Vital Verification
Just another day in the life of a DBA… … More Here I Come to Save the Daaay!