• 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."

    :crying:

    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, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events