Interviewing a DBA

PASS, SQL Server 2005, SQL Server 2008, SQL Server 2012, TSQL
I'm not a fan of trivia style interview questions. Yes, I ask a few because you have to in order to immediately eliminate the completely unqualified applicants. Even those types of questions, in my opinion, need to be focused on concepts and not syntax. The reason we have the Books Online with SQL Server is because you shouldn't have to memorize every possible command along with all their parameters. Want to know how to write a MERGE query? Look it up. What does a MERGE query do? That you ought to know. I think concepts are important. Questions about the recovery models within SQL Server aren't trivia about the system, they're trying to get to your understanding of how point in time recovery works. I don't really like posting interview…
Read More

Meme Monday: SQL Family

Professional Development
Tom LaRock’s (blog|twitter) question this month: What does #sqlfamily mean to me? Wow… Geez Tom, couldn’t you ask a hard question for once? Hmmm… Just saying #sqlfamily and a whole series of images of people flashes through my head. And those images are accompanied by all sorts of fun, amazing, interesting situations. And you know what, they’re all very positive. I don’t have flashes of people I dislike or bitter acrimony or really strange relationships. In short, maybe it’s not a family. I have a huge, complex, and very extended real-life family. When I compare that to my #sqlfamily, parts of the real family don’t shine quite so bright as that #sqlfamily does (parts, of course, shine brighter, I love my family). The #sqlfamily is impressive. I get so much…
Read More