+ Reply to Thread
Results 1 to 10 of 10
  1. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #1

    Default If you get chance check out the Murach SQl Server Dev 2012 book

    Lots of good information in there I mean a lot. Not a cert book but one of the very best reference manuals I have ever seen. I just sometimes just thumb through it and pick up all sorts of nuggets.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #2
    Thanks for the recommendation, just ordered the 2016 version.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #3
    It won't disappoint I am dead serious. He covers everything, using complex Derived Tables, CTE's, TEMP Tables and all sorts of crazy aggregating etc. That's just the first 5 - 6 chapters, out of 24 or so....
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #4
    Quote Originally Posted by nachodba View Post
    Thanks for the recommendation, just ordered the 2016 version.
    Did you ever get the 2016 version, if so how do you like it?

    IMO it's the Darryl Gibson Security + book in the SQL world. It's amazing, at least I think so.
    Reply With Quote Quote  

  6. Senior Member scaredoftests's Avatar
    Join Date
    Dec 2013
    Location
    behind you!
    Posts
    2,052

    Certifications
    ACAS,Comp TIA Security +, Novell CNE, HDI Customer Service, ITIL Foundation, MTA
    #5
    sold on amazon?
    Never let your fear decide your fate....
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #6
    https://www.amazon.com/Murachs-SQL-S.../dp/1890774960

    Oh yeah and it's beastly. If you know this book inside and out you are worth 100,000 easy in mid markets and 140+ in large markets, of course this is just my opinion. This book will give you all the techniques you need to be a successful SQL user / programmer, even some DBA task.

    It covers crazy weird things like 4 different types of lockings, all sorts of things. You could spend a year on this book and still need another year to learn it all. It's that thick in content.
    Reply With Quote Quote  

  8. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #7
    Quote Originally Posted by DatabaseHead View Post
    Did you ever get the 2016 version, if so how do you like it?

    IMO it's the Darryl Gibson Security + book in the SQL world. It's amazing, at least I think so.
    Yes, it arrived and I've been skimming through it. I can't wait to get some time to start working with it.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #8
    Sweet keep us posted!
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #9
    Went old school today. Hit the windowing section, page 200 and ended up using a really cool COUNT OVER PARTITION with an aggregate in the partitioning, instead of rejoining to a view 3 times I was able to set it up with the count over, much much better solution.

    I also used a SUM(CASE WHEN statement, I was coding the SUM in the case and was having to group and it was jacking up my result set, I saw a great example of enclosing the case with the SUM, really cool.....
    Reply With Quote Quote  

  11. Senior Member
    Join Date
    May 2016
    Posts
    1,647
    #10
    Did you all get a chance to review the book? Thoughts?

    I really like it, in fact I am going to use the XML chapter to solidify the nuggets I have been watching.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks