5 More Questions For Interviewing a Database Administrator

I’ve written before about interviewing a Database Administrator (DBA) and general hiring techniques. I’ve talked about how an interview should be a conversation, not a trivia contest.   I always describe the interview process as being a lot like being on a blind date. You shouldn’t be looking to stump someone during an interview. Memorization of obscure facts such … Read more

SQL Server 2014 In-Memory OLTP Hekaton Useful Links

SQL Server 2014 In-Memory OLTP Hekaton

SQL Server 2014 is nearly here. When it ships it will come with an “In-Memory OLTP” feature. This feature is generally known by its codename: Hekaton. Why that code name? Well, hekaton is Greek for a hundred, and that was the targeted performance improvement that Microsoft set out to achieve when building this new technology. … Read more

The 5 DBA Interview Questions You Have to Ask

Because the answers might surprise you. An interview should be a conversation, not a trivia contest. I’m not looking to stump someone during an interview. I don’t need for my DBA to know obscure facts such as database mirroring is only supported starting with SQL 2005 SP1. Memorizing such facts does not mean that you … Read more

Do You Make These 5 Database Design Mistakes?

Look, everyone makes mistakes. It’s true. But not all of us have the chance to make mistakes that end up costing millions of dollars in hardware and production support costs. Any one of the following five mistakes listed below will add additional costs to your company. It’s guaranteed. The costs could be hardware related (extra disk … Read more

A Better DBA Job Description For Everyone

Here is a typical job description that you can find online just about anywhere. It lists almost everything possible and imaginable. And it, well…I’ll just let you read it all for yourself and make up your own mind. Enjoy. Position Summary: This is a MS SQL Server DBA role largely responsible for providing operational database … Read more