Jack of all Trades.... ??
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Jack of all Trades.... ??

  1. #1
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346

    Jack of all Trades.... ??

    Hi,

    So, our company acquires a sqlserver based company, and we inherit their databases.

    So, having being an Oracle DBA for 7 years, I need to learn new tricks...

    Yes, we could port the databases over to oracle, but that's not gonna happen soon.

    So, for those of you who have experience of being dual rdbms DBAs, I'd appreciate it if anyone could recommend a good book for Sqlserver DBAs

    I've asked in SqlServerCentral.com, but their being miserable.....

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    We're 75/25 Oracle/SQL Server.

    "SQL Server 2000 Resource Kit"
    and
    "SQL Server 2000 Administrators Companion"

    Neither are light reading. They're big, heavy and very detailed. They're geared to the "IT Professional" and are definately not "for dummies" books.

    Best of luck,

    Ken

  3. #3
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Thanks Ken,

    Big, heavy and detailed is how I like my books ( and my women.... )

    Of the two books you mention, which is more suited to day to day DBA work, as they're probably expensive ?

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Resource Kit (list $69)

    Detailed .. as in clean or airbrushed well?

  5. #5
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Just detailed enough so you can recognise them when you're drunk

  6. #6
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Jeez.......

    That's 242 !! And that's for the paperback.....

    http://www.amazon.co.uk/exec/obidos/...449551-5745400

  7. #7
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    I would imagine that your company ought to be willing to pay for these ... having just bought an entire other company this ought to be chickenfeed.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  8. #8
    Join Date
    Jul 2002
    Posts
    335
    You're going to love SQL Server...

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,002
    You could start by reading Dilbert. You could also just open the gui and start clicking. Eventually something good will happen. If not you don't know me. Also if you get really stuck, I mean really stuck, start right clicking!

    Generally, schema's are databases, let dbo own everything, and learn the wizards. There isn't much to SQL Server. It is based on the Sybase database, but the code split 10 years ago or so. Make sure you upgrade the SQL Server 7 databases to 2000, as soon as you can.
    this space intentionally left blank

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    And remember the MCSE credo:

    If in doubt, reboot.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width