Recommendation on catching up with SQL from Older version

  • If you're used to working with SQL Server 2008R2 and to lesser extent, 2012 and now your company has moved to 2016 what would you recommend as a good method for getting up to date with T-SQL?

    I know the T-SQL basics so what I'm shooting for is getting up to speed with whats current in T-SQL up thru 2016. Whats changed, what was the method before and whats the method now for doing X?  For example I've always wrapped my updates in a try-catch statement, has this been replaced with a better method in 2016? What else may have changed between 2008R2 and 2016?

    Thanks

     

    Kindest Regards,

    Just say No to Facebook!
  • One thing I'd probably start with is go through the What's New In SQL Server <version> articles that Microsoft has in the documentation for the new releases. Here's the links for 2014 and 2016:

    What's New in SQL Server 2014

    What's new in SQL Server 2016

    Sue

  • Yep.  You'll need to go thru each "What's New" separately, for:

    SQL Server 2012; 2014; and 2016.

    SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply