Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Better Technical Interviews


Better Technical Interviews

Author
Message
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36143 Visits: 18747
Comments posted to this topic are about the item Better Technical Interviews

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8356 Visits: 6160
Give them a rope and let them hang themselves (metaphorically speaking).

Ask open ended questions and see how they handle themselves. Deliberately ask questions you think that they may not be able to answer in order to test both their integrity and explore how they would deal with leaving their comfort zone.

You don't have to be mean about it, after all you are doing the same for everyone including current team members who have been taken on.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Ed Wagner
Ed Wagner
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10280 Visits: 9578
I like the idea of having interviewers conduct interviews of some existing employees. We have to be able to separate a strong candidate who interviews poorly from a weak candidate who interviews well. I admit I find that to be difficult. I don't fall for sales pitches and usually see them for what they are, but I find that the interview process itself is too short to make a really well-informed decision.

I usually slip in a trick question that isn't possible and watch the reaction. If they're bluffing the interview, they're done. If they can admit they don't know, then that indicates honesty, which is important. The best example of this I've seen was posted (I believe by Sean Lange) who asks when the last time was that the candidate queried the transaction log to rollback a transaction that shouldn't have been performed. Granted, these will only take us so far.

Examples of work they're especially proud of AND something they're disappointed with are good topics too.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
johnbrown105 56149
johnbrown105 56149
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1199
The idea of hiring someone for a side project is a good one the most ridiculous thing that I have ever heard.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36143 Visits: 18747
johnbrown105 56149 (6/27/2013)
The idea of hiring someone for a side project is a good one the most ridiculous thing that I have ever heard.


because?

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
John Hanrahan
John Hanrahan
Say Hey Kid
Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)

Group: General Forum Members
Points: 672 Visits: 1449
I think that's sarcasm (I hope).
johnbrown105 56149
johnbrown105 56149
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1199
Steve Jones - SSC Editor (6/27/2013)
johnbrown105 56149 (6/27/2013)
The idea of hiring someone for a side project is a good one the most ridiculous thing that I have ever heard.


because?


I'm supposed to quit my job to work for you for a week on the chance that maybe, just maybe, I might be hired permanently? Do you genuinely think that this is not a ridiculous idea?
John Hanrahan
John Hanrahan
Say Hey Kid
Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)Say Hey Kid (672 reputation)

Group: General Forum Members
Points: 672 Visits: 1449
I think you misunderstood. Steve thinks you should work a few hours at home (after work) doing a small project over a week or two and get paid for it.

Personally I know many people who do this just to make extra money and would not consider it unreasonable to be asked to do this. This is in the US though maybe it's different elsewhere...
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36143 Visits: 18747
Perhaps we have different definitions of side project. As John H noted, this would be 15-20 hours outside your current job, nights, weekends, whatever.

This would assume you've gotten through an interview or two and both sides (employer and employee), want to move forward.

As a side note, if you didn't think this was a good idea, an explanation of why, or some reasons make sense. Jumping to conclusions and saying something is ridiculous doesn't seem like a thoughtful reaction.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
johnbrown105 56149
johnbrown105 56149
SSC Rookie
SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)SSC Rookie (40 reputation)

Group: General Forum Members
Points: 40 Visits: 1199
Steve Jones - SSC Editor (6/27/2013)
Perhaps we have different definitions of side project. As John H noted, this would be 15-20 hours outside your current job, nights, weekends, whatever.


Yes, it seems so. Your "side project" is 15-20 hours. I definitely was not thinking along those lines. I fail to see that what you could learn in that time that you could not find out in an old-fashioned interview.


As a side note, if you didn't think this was a good idea, an explanation of why, or some reasons make sense. Jumping to conclusions and saying something is ridiculous doesn't seem like a thoughtful reaction.


To be honest, it seemed self-evident to me. I struggle to see why anyone would have a different view.

Then there is the fact that this method does not scale, as you put it. Well, you got that right. You can assess exactly one person this way. How many 15-20 hour projects do you have lying around anyway?

This idea has no chance to work.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search