Free DBA Job Interview Q&A Course This Weekend
If you’re facing an upcoming SQL Server DBA job interview, or if you’re a manager who has to interview DBAs, I want to help. This weekend, I’m giving away my DBA Job Interview Questions & Answers course absolutely free!
Just hit up my training product page, find the DBA Job Interview course, add it to your cart, and check out with coupon code TikTok.
In that course, I give you questions for core DBAs, infrastructure, development, screenshot-based questions, open-ended questions, and more. I read the question, then I pause to let you answer it, and then I tell you what I was looking for in a great answer.
I did a quick live version of the first few questions if you’d like a feel for it:
I hope it helps make the DBA job interview process suck a little less for everybody involved. Cheers!
4 Comments. Leave new
As a Dutch person I selected the Euro payment option, the discount code didn’t work there, selected the USD option and the code work perfectly.
On the first question, some folks will need that second question about what file types they’ll be. I’d be MUCH more impressed by the folks that don’t give you a need to ask the second question. The should respond to the first quest with “Two files. One is the “data” file and the other is a “transaction log file”. The default extensions on the files are .MDF and LDF, respectively. The old recommendation of having these on the same drive has become a bit contentious in the general public but I still prefer them to be on separate drives for both performance and safety reasons. You can have addition files of both file types but the transaction log is serially used and having multiple files for that usually makes no sense unless it’s just a leftover from an out-of-disk space problem (and that needs to be fixed)”.
In other words, you’re on an important interview where you need to show your stuff…. now’s your chance to show off that you have the “Right Stuff” without being arrogant or condescending.
If they say “Extra information is not necessary”, you might want to reconsider your interest in working in such a shop. Remember… you’re also testing them for “fit” without letting them know that they’re being tested ;-).
EDIT: And I posted above right after the 2nd question. I see you covered some of the above on the additional questions like those about the Model Database.
I completely agree with you about separating drives for log and data due to having growth sequentially in log files. I was part of a large organization with many physical servers so we needed to have different raid types for their disks as well and we used to consider raid 1 (mirror) for log drive and raid10 for data. I meant separation helped us manage resources too.
Best $0 that I ever spent! I love learning from Brent and wanted to update my interview questions for interviewing candidates. Great course, thanks!