+ Reply to Thread
Results 1 to 10 of 10
  1. Senior Member tdean's Avatar
    Join Date
    Mar 2009
    Posts
    522
    #1

    Exclamation Well, I'm the new SQL guy at work...

    ...and I've never used it prior to this month. So far i have set up a cluster with 2 nodes, 18 instances and moved 12 databases. I would like to know what you guys think are the best books out there for someone just starting. Should i go with the 2008 books? or 2012? Are there books that cover design (clustering, lun allocation etc), optimization, and querying? Should i get them individually? I'f im going to be the guy, im going all the way. I have read all the book recommendations above. I was just hoping someone could narrow them down for me.

    To be more clear, I've looked at the "Joes for Pros" series, the DB for Mere Mortals, all the Sams, MS training kits and Step by Step books.
    Last edited by tdean; 03-24-2015 at 06:36 PM.
    Reply With Quote Quote  

  2. SS -->
  3. Member pandiculator's Avatar
    Join Date
    Mar 2014
    Location
    England
    Posts
    41

    Certifications
    MCSA 2008, MCSA 2012
    #2
    I can't recommend a book for certification but an excellent book for systems administrators thrown in at the deep end with SQL is Don Jones's Learn SQL Server Administration in a Month of Lunches. It's a fantastic introduction to SQL server administration and it will give you a foundation to build on if you want to take the steps to get certified or become a DBA. The link has a couple of sample chapters so you can see if this book will be of any help to you before buying.
    Reply With Quote Quote  

  4. Senior Member tdean's Avatar
    Join Date
    Mar 2009
    Posts
    522
    #3
    Quote Originally Posted by pandiculator View Post
    I can't recommend a book for certification but an excellent book for systems administrators thrown in at the deep end with SQL is Don Jones's Learn SQL Server Administration in a Month of Lunches. It's a fantastic introduction to SQL server administration and it will give you a foundation to build on if you want to take the steps to get certified or become a DBA. The link has a couple of sample chapters so you can see if this book will be of any help to you before buying.

    I saw that one.... Might be a good place to start. I dont even really know what questions to ask. I almost bought a whole series of books and noticed they are for T-SQL... which i still dont know what it is.
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #4
    T- SQL is Transact SQL, Microsoft's flavor of SQL. PL-SQL is Oracle's.
    Reply With Quote Quote  

  6. Member
    Join Date
    Feb 2015
    Location
    South Africa
    Posts
    60

    Certifications
    , SAP Business One, ITIL, MCSA SQL 2012
    #5
    Microsoft's 70-462 is aimed at exactly what your doing

    Best one to get your interest going is actually online with the Microsoft Virtual Academy

    Course is called 'Administering SQL Server 2012'

    Covers everything Microsoft thinks you should know, and its free,

    That one is aimed directly at you, for the kind of work your doing right now

    Querying SQL

    70-461, MVA course is called 'Querying SQL server' which is T-SQL. Not for the faint hearted, but really cool if you want to go and play.

    I just finished 70-461, will let ya know how I go in prep for 70-462.
    Reply With Quote Quote  

  7. Senior Member tdean's Avatar
    Join Date
    Mar 2009
    Posts
    522
    #6
    Awesome info! i'll check out that course and maybe go for the 462 course before the 461. For books, i was thinking about the 2008 Admin in Action and the 2012 T-SQL Fundamentals for now. Unfortunately at work, we are 2008 R2 but if i want to take this to the next level, or any level, im going to need to understand this stuff from top to bottom.
    Reply With Quote Quote  

  8. Member
    Join Date
    Feb 2015
    Location
    South Africa
    Posts
    60

    Certifications
    , SAP Business One, ITIL, MCSA SQL 2012
    #7
    So
    Next level

    Go download SQL server 2014 Express Edition, free from Microsoft's website. Limited in function, but fully working, and comes with all the toys

    Download the Adventureworks database, which is also free.

    Most courses and books use the adventureworks database as an example.

    With that dataset, and free SQL 2014, go play to your hearts content.

    On the MS Site, there are 4 versions you can download, get the big one, 1gb i think

    It has all of the toys such as the management studio, SSIS ect...
    Reply With Quote Quote  

  9. Senior Member tdean's Avatar
    Join Date
    Mar 2009
    Posts
    522
    #8
    Do you guys think these books are a good place to start? I'd like to get something in hand to get a away from a computer screen for a while.

    2008 Admin in Action and the 2012 T-SQL Fundamentals
    Reply With Quote Quote  

  10. Junior Member Registered Member
    Join Date
    Feb 2015
    Location
    Cleveland, OH
    Posts
    4
    #9
    I'm not familiar with the Admin in Action but the T-SQL Fundamentals is highly recommended for anyone interested in Microsoft SQL.
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #10
    I find these books because obsolete rather quickly. Either you pick up on SQL quickly or you don't. You have to be able to think in sets and if you are good at thinking in sets, then the examples in these books dry up and become very elementary.

    I find Google is my best teacher in times of need of a new theory or piece of code.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks