Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Posts
    10

    Unanswered: Recommendation Requests: Learning MS SQL Server for Sybase DBAs

    Hello,

    I have been working as Sybase DBA for 5+ years, and I would very much like to add MS SQL Server to my resume. Given the common roots of the two RDBMS, it seems that the learning curve would not be as sharp as if I were going to learn Oracle or DB2. Can anyone out there know of any books that are geared toward learning MS SQL Server from a Sybase DBAs perspective?

    Thank you,

    - Chris Merz

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Assuming you've got a good understanding of Sybase, and want to take the "rocket sled" approach to getting into Microsoft SQL, I'd recommend Kalen Delaney's Inside Microsoft SQL Server 2000, but it is NOT for the faint of heart!

    A slightly more civilized approach, would be Ken Henderson's The Guru's Guide to Transact-SQL. This takes a bit smaller bite in that it focuses on the programming side only, not on theory or administration, but it gets the job done and isn't nearly as overwhelming.

    A good "split the difference" between those two would be Richard Waymire's Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days. This book covers almost everything you need to get started (and then some), and does it at a tolerable pace for most technical users. It gives you a good "middle ground" between the other two, and enough background for 98% of what you're likely to need for most SQL implementations.

    If none of these suit you, give me some feedback on why they don't and I'll try to give you another suggestion.

    -PatP

  3. #3
    Join Date
    Jun 2002
    Posts
    10
    Thanks, Pat. I will certainly check out your recommendations, and I'll post my experiences back in this thread. I have been focusing more on administration than development over the past couple of years, so I will probably begin with the Delaney book.

    select * from users where heart_attrib like "%faint%" and userid = "zremdog"
    go

    (0 rows returned )

    :-D

    Thanks again for your input.

    -Chris

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    the delaney book is not really an administration book. it is more like a quick look at the basics and then grinding details about the internals. do not get me wrong, it is a great book if you want to get real serious about SQL Server but I have to tell you I have not yet found myself using DBCC PAGE in the workplace.

    As for a great administration book, I have not read one. Books Online, maybe?
    “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
  •