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 «««45678»»»

SQL DBA high ended question (5+ years’ experience) Expand / Collapse
Author
Message
Posted Thursday, August 7, 2014 8:48 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 11:46 AM
Points: 431, Visits: 1,738
Eirikur Eiriksson (8/6/2014)
Jeff Moden (8/5/2014)
rajeshn29.dba (8/5/2014)
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot :
Rajesh


You're the newly hired Sr. DBA for a company. There are no other DBAs. The previous DBA quit a month ago.

Explain in great detail what your first "real" day (normally, the 2nd actual day. The first actual day is usually wasted on paper work and seeing if you can handle a specimen cup without getting your hands wet, etc) will consist of.

On the 3rd "real" day, a database becomes corrupt. What actions will you take?


Another version: On the 3rd "real" day, you are told that a database "may be" corrupt. You look into it and find that it has been so for months....



First day:

"What's the sa password?"

"It's written on the whiteboard by the developers."




Post #1600679
Posted Thursday, August 7, 2014 8:55 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 6:52 AM
Points: 499, Visits: 1,821
Or worse "It's Password, with a capital P".
Post #1600686
Posted Thursday, August 7, 2014 8:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 11, 2014 3:16 PM
Points: 256, Visits: 1,467
"sa doesn't need a password."
Post #1600688
Posted Thursday, August 7, 2014 9:13 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:08 PM
Points: 3,629, Visits: 7,909
Beatrix Kiddo (8/7/2014)
Or worse "It's Password, with a capital P".

That isn't policy compliant, it needs to be P4$$w0rd as shown on MS courses.



Luis C.
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1600698
Posted Thursday, August 7, 2014 9:16 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 21,724, Visits: 15,409
sqldriver (8/7/2014)
Eirikur Eiriksson (8/6/2014)
Jeff Moden (8/5/2014)
rajeshn29.dba (8/5/2014)
Hi Friends,
I would like to know SQL DBA high ended question (5+ years’ experience) what kind of questions they will ASK …………………. Just for curiosity
Thanks a lot :
Rajesh


You're the newly hired Sr. DBA for a company. There are no other DBAs. The previous DBA quit a month ago.

Explain in great detail what your first "real" day (normally, the 2nd actual day. The first actual day is usually wasted on paper work and seeing if you can handle a specimen cup without getting your hands wet, etc) will consist of.

On the 3rd "real" day, a database becomes corrupt. What actions will you take?


Another version: On the 3rd "real" day, you are told that a database "may be" corrupt. You look into it and find that it has been so for months....



First day:

"What's the sa password?"

"It's written on the whiteboard by the developers."






Go ask the CTO administrative assistant. She has it on a posty note under her keyboard.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1600702
Posted Thursday, August 7, 2014 9:27 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 11:46 AM
Points: 431, Visits: 1,738
Oh, you guys thought I was kidding. Heh.

Post #1600709
Posted Thursday, August 7, 2014 9:29 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 21,724, Visits: 15,409
sqldriver (8/7/2014)
Oh, you guys thought I was kidding. Heh.



No. I have quite literally run into that type of thing. Both as you described and as I described.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1600712
Posted Thursday, August 7, 2014 9:43 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 11:46 AM
Points: 431, Visits: 1,738
SQLRNNR (8/7/2014)
sqldriver (8/7/2014)
Oh, you guys thought I was kidding. Heh.



No. I have quite literally run into that type of thing. Both as you described and as I described.


If the OP is still reading this: a good question to ask the person interviewing you is "what happened to the last guy?".
Post #1600721
Posted Thursday, August 7, 2014 9:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 5:36 PM
Points: 13,418, Visits: 12,283
SQLRNNR (8/7/2014)
sqldriver (8/7/2014)
Oh, you guys thought I was kidding. Heh.



No. I have quite literally run into that type of thing. Both as you described and as I described.


Same here. I once had a boss who went out of town and she handed me her notebook with all of the network passwords and such in there. She was a little over trusting since the same page had website addresses, usernames and passwords for all her personal stuff too (like banking, credit cards etc).


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1600730
Posted Thursday, August 7, 2014 10:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 21,724, Visits: 15,409
Sean Lange (8/7/2014)
SQLRNNR (8/7/2014)
sqldriver (8/7/2014)
Oh, you guys thought I was kidding. Heh.



No. I have quite literally run into that type of thing. Both as you described and as I described.


Same here. I once had a boss who went out of town and she handed me her notebook with all of the network passwords and such in there. She was a little over trusting since the same page had website addresses, usernames and passwords for all her personal stuff too (like banking, credit cards etc).


Well, i guess if anything happened, she knew who to ask first.

But that wouldn't stop some prying eyes from taking a peak at her financials.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1600748
« Prev Topic | Next Topic »

Add to briefcase «««45678»»»

Permissions Expand / Collapse