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

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.
LVL 67
Jim HornMicrosoft SQL Server Data DudeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zephyr_hex (Megan)DeveloperCommented:
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 HornMicrosoft SQL Server Data DudeAuthor Commented:
Client has an Enterprise license, so Enterprise only will do nicely.
Vitor MontalvãoMSSQL Senior EngineerCommented:
I have the more important ones on the top of my head. Is that helpful? :)
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Jim HornMicrosoft SQL Server Data DudeAuthor 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 EngineerCommented:
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
Jim HornMicrosoft SQL Server Data DudeAuthor Commented:
Just received this from a Microsoft employee buddy of mine ... Compare SQL Server versions

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Thanks for sharing, Jim.
Pawan KumarDatabase ExpertCommented:
@Author - please let me know if you need more cheat sheets.
Jim HornMicrosoft SQL Server Data DudeAuthor 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 ExpertCommented:
@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 HornMicrosoft SQL Server Data DudeAuthor 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 HornMicrosoft SQL Server Data DudeAuthor 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 ExpertCommented:
No problem sir !! Going forward will keep that mind.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.