• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 141
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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