+ Reply to Thread
Results 1 to 11 of 11
  1. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #1

    Default Hello fellow database enthusiasts

    I was certified a long time ago in a galaxy far, far away in Administering SQL 7.0. I've since been working with production databases in SQL 2000, 2005 and 2008R2 (simple databases maybe 100 users, maybe a GB max no clustering or log shipping, etc). I've always bought myself the developers edition for every release with full intentions of getting my Administering SQL Server 2012 Databases certification. I've downloaded the changes from SQL 2012 to SQL 2014 and I have the Microsoft Press study guide for the 70-462. Is that book supplemented by TechNet adequate to pass the exam? I'd be purchasing test exams.

    Any feedback would be greatly appreciated.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    100

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #2
    Quote Originally Posted by AvgITGeek View Post
    I was certified a long time ago in a galaxy far, far away in Administering SQL 7.0. I've since been working with production databases in SQL 2000, 2005 and 2008R2 (simple databases maybe 100 users, maybe a GB max no clustering or log shipping, etc). I've always bought myself the developers edition for every release with full intentions of getting my Administering SQL Server 2012 Databases certification. I've downloaded the changes from SQL 2012 to SQL 2014 and I have the Microsoft Press study guide for the 70-462. Is that book supplemented by TechNet adequate to pass the exam? I'd be purchasing test exams.

    Any feedback would be greatly appreciated.
    I've also been using SQL Server since v7. I passed 70-462 (narrowly) using just the Microsoft study guide, which I think is quite good. The most difficult part for me was learning all the different clustering and replication options, it's difficult to master those without several servers to practice on.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #3
    From one SQL Dinosaur to another Thanks for that. It makes me a little more comfy regarding taking the exam. How did you lab?
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Oct 2015
    Location
    UK
    Posts
    100

    Certifications
    MCSD (Web), MCSA (SQL Server 2012/14), AWS Architect (Assoc.)
    #4
    Mostly I just used a single server for the labs. I did have access to a test Active/Passive cluster and log-shipping configurations at work, but for the some of the replication options, I just read the book really carefully.
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #5
    Good to know. Thank you!
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #6
    Good luck on 462. Database dev here, not much of a dba but do love working with a good one.
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #7
    My development really stopped with SQL 2000. Our ERP was SQL backend with an Access front end so I'd do all the report writing\creating new tables\sprocs\views\etc. I really miss writing queries so I'll probably end up taking 461 at some point.
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #8
    Agreed loved it myself.

    Will be a sad day when I move onto something else, it happens to most of us.

    Anyway until then I'll keep churning out code.


    Here you go, blast from the past

    https://images-na.ssl-images-amazon....4,203,200_.jpg
    Last edited by DatabaseHead; 02-08-2017 at 07:31 PM.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #9
    Hahahaha! My parents said "really?" when I asked for and then got this for christmas...
    SQLServer2000Programming.jpg

    I still have it in a box of books on my floor. I had to pull it out to make sure I got the title right.

    I dug it out.
    image1.JPG
    Last edited by AvgITGeek; 02-10-2017 at 01:38 AM.
    Reply With Quote Quote  

  11. Senior Member Chev Chellios's Avatar
    Join Date
    Jan 2013
    Location
    UK
    Posts
    336

    Certifications
    MCP, MCDST, CCNSP, ITIL Foundation, working towards CCENT/CCNA
    #10
    Haha AvgITGeek, great book choice there!
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #11
    The thing must weigh close to 5 pounds. Sucker is massive but learned a lot from it.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks