My Biggest Regret as a Database Administrator

Is one simple, small thing. It’s not spending as much time as I possibly can with other people.

These Are Actual People

A DBA’s Time Is Limited

There’s almost always more things to be done that a DBA has time for. Some people I know are great database administrators because they’re very great parent types– they’re responsible, they’re organized, they like to keep everything in line, and they want to take care of something and raise it up to behave right and do well in the world. They actually care about their databases– I don’t mean this as a metaphor, they actually care about them.

But a database is a hard thing to love. It doesn’t talk, or think. It’s really just a bunch of 1′s and 0′s. It’s not that caring is bad, it’s just that if you care too much about your database then you end up stuck in the details of the thousand and one things that threaten its perfection.

And, Seriously, People Have Issues

This is clearly true in more than one sense.

Yeah, other people have reality TV issues. And they also have data issues. Can you make this query run faster? Oh, and these numbers don’t add up. What was the cause of the outage last week? Have you released this new code yet?

When are you planning to apply the latest patches? What new features are available in the next version? Is this table in replication? If so, what will happen when I remove these three columns? Oh, and by the way, we want to do some key changes on that billion row table.

Have you refreshed the preproduction environment? The dev server won’t start up. Can I have your IM address?

But Still, The People Are What’s Most Important

Really. I mean this.

It’s fairly obvious that I’m a serious geek and a technical person at heart. I have fancy certifications, a giant stack of books, and I know a TON of acronyms: that’s gotta be good enough to show something, right? But still, I’m the one who’s sitting here and saying that other people are what got me where I am today more than anything else. It’s 100% true. As much as I’ve tried to teach myself things from the internet, from classes, and from books, 99% of my knowledge has come from users, sys admins fellow DBAs, and developers in the trenches. Even (GASP), my SAN admins.

These other people who taught me what an index does and how to get that query to use it. They showed me how to tell why things are slow in SQL Server. They taught me how to build out hardware and how to figure out what components go into a SAN. My coworkers taught me how to build software and how to make it better every single day. Sometimes it was their job to teach me, sometimes they were just good people, and sometimes we were just having fun. I tried to give back as much as I could, but looking back it’s hard to express how grateful I am for all of that help along the way.

As a DBA, I’ve always spent a lot of time with people. But my biggest regret is not spending even more time, and not listening even more. Because working with people has always been the very best part of my job. Your coworkers will give you so much, if you just let them.

Comments { 3 }

The #1 Thing You Forget to Do Before Presenting

You’ve painstakingly written and practiced your demos. You’ve polished your slides. You’ve walked through each moment of your talk– maybe it was in front of your dog, maybe it was in front of your ever-patient spouse, but you’ve given it your all. There’s something you’re probably forgetting. The Moment of Naked Honesty: Plugging In As [...]

Comments { 0 }

DBA Confession: Sometimes Everyone’s the Slow Kid

I’ve been working with SQL Server databases, Windows administration, and software development an awfully long time. Once you have a lot of experience with something, it’s easy to forget what’s not obvious to newbies. But some things you have to learn the hard way. There’s a lot of stuff that I “just know” now and [...]

Comments { 6 }

Conference Prep List: Pick Your Workout

I got an email recently from a first time attendee to the SQL PASS conference that made me squeal with glee. The email asked the question: do you know a good place to go do Crossfit in Seattle? I somehow hadn’t realized that I could plan workouts for the conference, and I was so glad [...]

Comments { 2 }

Embedding YouTube Videos in WordPress Blog Posts

I came to YouTube late in life. For years, I used it so rarely that I usually couldn’t remember if it was “YouTube” or “UTube”. No matter who you are, your mom is very likely more experienced at using YouTube than I am. It’s OK, I gave up on being cool many years ago. These [...]

Comments { 2 }
Database Under Attack

Forms of Database Torture (Illustrated)

Many forms of disasters can happen to a database. Here are three I’ve seen lately. My Database Is On Fire My Database Has Been Hacked My Database is Responding Erratically

Comments { 4 }

Are You Following Your Dream?

I got my first “real” job working with databases in New York City in the early 2000′s. The woman who hired me was incredibly smart, and a pleasure to work for. She understood how mainframes processed data, the need and challenge to create web interfaces and relational databases that would work well with mainframes, and [...]

Comments { 1 }

A Place For My Stuff: Where Did My Posters and Partitioning Page Go?

The great philosopher, George Carlin, famously claimed that the meaning of life is trying to find a place for your stuff (NSFW– it’s George Carlin, after all). My Stuff Was in More than One Place … and my stuff was getting hard to update. I’m working on creating a balance so I can regularly create content [...]

Comments { 0 }