Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Testing Skills

By Steve Jones,

This editorial was originally published on May 11, 2009. It is being re-run as Steve is on vacation.

How can you measure someone's skills? Is there a good way to actually assess how well a DBA or developer will do in your company? If you have one, there is some money to be made by passing the information along.

Traditional interviews where you ask lots of questions typically haven't necessarily proven to be a great way to do this.  Some people give tests, but they often are thrown together, and might contain multiple choice answers to make them easy to grade. However the other day someone posted a technique they used that I liked.

This person suggested that a VM be configured with Windows and SQL Server and then with a certain number of things wrong with the install. Or at least things that would be seen as wrong in that particular  environment. You then give it to a candidate and ask them to tell you what's wrong. You could let them work through it in a stream of consciousness way, telling you what was wrong as they found it. You could also give them some time, say an hour, and then come back and let them explain what is wrong.

Actually I'd recommend you give the candidate the choice since some people work better alone.

I've thought about asking them to accomplish certain tasks before, but after considering this technique, I like it a bit more. Just asking them "what's wrong?" or "what would you change?" is a good way to see how people think. Interacting with them, getting them to dig into a real system, is a great way to assess not only technical skills, but also some interaction. See how they debate, argue, or question a co-worker is important, at least it's important to me.

Is this is a better way to interview people and assess skills? Would you like to be interviewed like this? Maybe this would even be a fun competition at somewhere like the PASS Summit.

Steve Jones

Total article views: 758 | Views in the last 30 days: 2
 
Related Articles
FORUM

PreVisor Assessment Test

PreVisor Assessment Test

FORUM

Interview

Interview

ARTICLE

Oddball Interview Questions

Today we have a guest editorial from Andy Warren. He talks about strange questions in interviews and...

FORUM

interview questions

need to know interview questions

ARTICLE

Interviewing

How should you interview for that new DBA job? What is appropriate and what should you leave out? St...

Tags
career    
editorial    
interviews    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones