Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2007
    Posts
    91

    Unanswered: SQL Server DBA newbie

    Hi Guys. Am not sure if i'm posting in the correct place. I just got an opportunity to be a DBA. I need to know what do i need to concentrate on and train myself on, in order to prepare for the role and be a good DBA. I would greatly appreciate your advise

    Thanks
    Last edited by noks; 08-26-08 at 07:37.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    do you have a sql server to play with? if not download sql express or spend $50 and get a copy of the developers edition.

    after that just start reading everything you can get your hands on including but not limited to SQL Server Books Online, Inside SQL Server books, websites (this one sqlperformance.com, sqlteam.com etc...) .

    good luck. use test environments and make backups whenever possible.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    First and foremost, learn SQL, it will be needed whether you're developing code, SSIS, DTS, or doing pure server admin (sometimes you need a back door to the GUI based tools[sarc]) and as Thrasy says, Backups are the holy grail of DBA-hood.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Find out what your responsibilities are. "DBA"s can have a wide range (or sonmetimes very narrow) focus.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by pootle flump
    Find out what your responsibilities are. "DBA"s can have a wide range (or sonmetimes very narrow) focus.
    Prime example, at Diageo, all I did were server installs (SQL and Oracle on WinNT), and scripted backup and maintenance routines, whether DOS Shell or UNIX Shell, there was no development whatsoever.

    Now, I am at a hedge fund doing more development than admin, so the job of DBA can have a wide or narrow focus as PF says.
    Last edited by PMASchmed; 08-26-08 at 10:15.

  6. #6
    Join Date
    Mar 2007
    Posts
    91
    I do have sql server 2005 to play with. I know the basics of sql, DML and DDL but never worked with huge databases. I've been trying to get soft copies for tutorial or anything i can use for the practical training but not succeeding

    Thanks guys. I'll try the suggested site

  7. #7
    Join Date
    Mar 2007
    Posts
    91
    Quote Originally Posted by PMASchmed
    Prime example, at Diageo, all I did were server installs (SQL and Oracle on WinNT), and scripted backup and maitenance routines, whether DOS Shell or UNIX Shell, there was no development whatsoever.

    Now, I am at a hedge fund doing more development than admin, so the job of DBA can have a wide or narrow focus as PF says.
    mhhhhhhh interesting. I guess i'll have to ask for the spec as i went to the company for an interview for an application support post but through out their assessments they decided to take me on as a DBA

    Thanks guys

  8. #8
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by noks
    mhhhhhhh interesting. I guess i'll have to ask for the spec as i went to the company for an interview for an application support post but through out their assessments they decided to take me on as a DBA

    Thanks guys

    Larger companies will have you focus more on a specific area than a smaller company where you need to be more of a jack of all trades, it's very hard to find a happy medium. The guy I took over for here was a Java programmer acting as DBA.

  9. #9
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    I dunno. Everyone expects me to know everything about everything everywhere I go. I try not to let them down too hard.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •