Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
opiegonebad
Starting Member
1 Post |
 Posted - 2008-12-02 : 12:29:36
|
| All,We are in the process of trying to hire a knowledgable, experienced dba to support our sql 2005 environment.The problem is is we do not know enough about sql to make good decisions. Nor do we know the questions to ask of the canidates.Are there any of you out there who could suggest a few questions we might ask the potential dba's and provide the answers also?ThanksMichael |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-12-02 : 16:07:51
|
| There are plenty of interview questions on the internet . But should also look for attitude. e.g willingness to solve problems, organisations, approach to troubleshooting performance issuesJack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2008-12-02 : 16:09:05
|
| One of the tasks that is critical for any DBA to know is backup and restore procedures. I would ask something along the lines of:"What recovery model would you recommend for a critical production database?" (The answer should be "Full")The followup should be something like, "If you use Full Recovery, the transaction logs can get quite large. How would you keep them manageable?" (The answer is, back them up often, and if necessary, shrink the log file)For recovery, I would ask something like:"A developer just accidentally deleted critical information in a production database running in Full Recovery. How can we recover the data?" (The answer is, back up the transaction log, restore the database from the last full backup, and replay all the transaction logs up to the point of the deletion)... an experienced DBA will recommend doing this on another server and just recovering the data lost to the production machine... and then he will go on about restricting developer access to production systems.___________________________Geek At Large |
|
|
|
|
|
|
|
|
Questions to ask a dba for sql 2005