Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««89101112»»»

Common questions asked in SQL Server DBA Interview Expand / Collapse
Author
Message
Posted Tuesday, August 18, 2009 8:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:58 AM
Points: 13,872, Visits: 9,600
Abbi: Not a good idea to post your e-mail address openly on web pages. Spammers use bots to scan for that kind of thing and you'll get into their lists that way.

I recommend editing the post and removing the e-mail address from it, or at least obscuring it so a bot can't read it.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #772792
Posted Tuesday, August 18, 2009 9:05 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 5,676, Visits: 6,488
abbi1680 (8/18/2009)
Hi,
Could you please email me the screening sql server dba questions.


Apparently you haven't been reading this topic closely enough. There's no list. Different companies ask different questions. It's not like a cert exam where you can study for it and pass based on memorized answers.

I am a sql dba and would be looking out for a job.


Great, then you don't need a list. Presumably you know your job well enough to answer any question put to you or to be honest enough when you don't know a question. Remember, the interviews are as much about soft skills as they are about you knowing SQL Server.

If you're really concerned, check out your local SQL Server Users Group and see if you can find a mentor to do mock interviews with you. Or ask your local contracting firm if they offer mock interview courses.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #772801
Posted Tuesday, September 8, 2009 9:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:13 AM
Points: 2,704, Visits: 1,149
I liked the questions that Grant linked to in his 1st page post, but they are pretty basic.

IMHO it depends purely on the role. Some of the questions I have had, made me speechless at the time, you can never know everything.

basic stuff like
what is the difference between a clustered index and a unique index
name all the types of constraints
name all the database roles

to stuff like
how do you clone a report server
when do you use a cursor
tell me about large databases and how you would treat them different to small databases
The user has reported the server is slow, how do you troubleshoot the problem.
High availability which is better clustering or mirroring and why
tell me briefly how you set up clustering and which services are not cluster aware
how do you service pack a cluster, explain for both active active and active passive
how does pier to pier replication work


the list goes on and these are questions that I have been asked before.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #784352
Posted Tuesday, September 8, 2009 9:58 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
I'm in a silly mood right now, so...

Silverfox (9/8/2009)
how do you clone a report server
Start with a bounty hunter and a water-covered planet.

when do you use a cursor
As seldom as possible

tell me about large databases
They're big

and how you would treat them different to small databases
Give them more drive space and ignore them. SQL manages itself after all. (sic)
The user has reported the server is slow, how do you troubleshoot the problem.
Ignore them. If it's a serious problem, they'll call back

High availability which is better clustering or mirroring and why
Yes.

how does pier to pier replication work
Recruit some strong deck hands and get them to carry the stuff.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #784369
Posted Wednesday, September 9, 2009 7:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:46 AM
Points: 5,676, Visits: 6,488
Gail,

You're hired! Come on over to Florida and we'll discuss your exhorbitant salary that is totally off the scale compared to the DBAs we currently have now who foolishly assumed we wanted complicated answers to the interview.

@=)


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #784919
Posted Friday, September 10, 2010 8:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 16, 2011 4:50 AM
Points: 1, Visits: 5
How many dba’s and servers are using in organization
Post #983843
Posted Friday, September 10, 2010 9:05 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
New questions in a new thread please, and be specific if possible


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #983863
Posted Friday, October 8, 2010 9:42 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:00 AM
Points: 464, Visits: 1,533
This is not a new question . He actually replied to original post question which is "Common questions asked in SQL Server DBA..."
Post #1001414
Posted Friday, October 8, 2010 1:32 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 1,510, Visits: 8,470
Brandie Tarvin (9/9/2009)
Gail,

You're hired! Come on over to Florida and we'll discuss your exhorbitant salary that is totally off the scale compared to the DBAs we currently have now who foolishly assumed we wanted complicated answers to the interview.

@=)


Not too fast Brandie. Gail left out something important.

and how you would treat them different to small databases

Give them more drive space and ignore them. SQL manages itself after all. (sic)


She forgot the part about setting the datafile autogrowth to 25% instead of the default 10%








Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #1001565
Posted Friday, October 8, 2010 1:37 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 40,615, Visits: 37,080
Please note, resurrected year-old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1001569
« Prev Topic | Next Topic »

Add to briefcase «««89101112»»»

Permissions Expand / Collapse