Does anyone have a 'What's new in SQL Server {version number} cheat sheet?

Jim Horn
Jim Horn used Ask the Experts™
on
Hi all

I have a client that is currently on 2008R2 and is looking to upgrade, and has tasked me to come up with a big grid of 'What's new in SQL Server {version number}' for all versions 2008R2 forwards.  The attached spreadsheet is a start.

Does anyone have one of these already made?

Note:  I am NOT looking for a collection of links that feature everything that a specific version does, or five links of solely what's new with a specific version, as I've already found those.

Thanks in advance.
Jim
SQL-Version-Comparison.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
Are you looking at a specific edition, or all editions?  I don't have a list, but thought you might want to clarify since features differ across editions as well as versions.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Client has an Enterprise license, so Enterprise only will do nicely.
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017

Commented:
I have the more important ones on the top of my head. Is that helpful? :)
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Yes, as everyone knows us experts are great at mind reading..  :)

Also I asked some Microsoft friends this question, and all they were able to produce was everything available in 2016, where the word 'cloud' or 'Azure' appeared in at least every other sentence.
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017
Commented:
MSSQL 2012 (focus in BI):
  • AlwaysON; ColumnStore Index; Contained databases; Sequence and better Auditing

MSSQL 2014 (focus in Performance):
  • Enhanched AlwaysON and ColumnStore Index; In-Memory tables

MSSQL 2016 (focus in Security)
  • AlwaysEncrypted; Data Masking; R language; Stretch database
SQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Just received this from a Microsoft employee buddy of mine ... Compare SQL Server versions
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017

Commented:
Cool.
Thanks for sharing, Jim.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
@Author - please let me know if you need more cheat sheets.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Pawan - Thank you for posting the attachments, but they have nothing to do with the question.   You'll also want to be very careful using other people's work without crediting them.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
@Jim - I have those sheet since long and they have their authentic owners mentioned in the pdf.  Any one who will read those will get the actual owners work with their names. I am just spreading the word. I dont think anything incorrect with that. If you want I can delete my comment. Please let me know.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
I have a cheat sheet that shows what everyone should do in the sport of ice hockey depending on where the puck is, and just like your cheat sheets it is completely unrelated to the question.   So regardless of correct or not correct posting them added no value.

If you'd like to show off your cheat sheets then an article would be a more appropriate forum, but then again articles have to be your own work and not something copied from someone else.
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Pawan - Please refrain from closing my questions.  I'd like to keep this open to see if any new information trickles in.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
No problem sir !! Going forward will keep that mind.

Bye,
Pawan

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial