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) A socialist is someone who will give you the shirt off *someone else's* back.

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

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