• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 160
  • Last Modified:

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.
Jim
SQL-Version-Comparison.xlsx
0
Jim Horn
Asked:
Jim Horn
  • 6
  • 3
  • 3
  • +1
2 Solutions
 
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.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Client has an Enterprise license, so Enterprise only will do nicely.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I have the more important ones on the top of my head. Is that helpful? :)
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor 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.
0
 
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
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Just received this from a Microsoft employee buddy of mine ... Compare SQL Server versions
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Cool.
Thanks for sharing, Jim.
0
 
Pawan KumarDatabase ExpertCommented:
@Author - please let me know if you need more cheat sheets.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor 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.
0
 
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.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor 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.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Pawan - Please refrain from closing my questions.  I'd like to keep this open to see if any new information trickles in.
0
 
Pawan KumarDatabase ExpertCommented:
No problem sir !! Going forward will keep that mind.

Bye,
Pawan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 6
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now