Solved

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

Posted on 2016-09-09
15
97 Views
Last Modified: 2016-10-11
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
Comment
Question by:Jim Horn
  • 6
  • 3
  • 3
  • +1
15 Comments
 
LVL 42

Expert Comment

by:zephyr_hex
Comment Utility
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
 
LVL 65

Author Comment

by:Jim Horn
Comment Utility
Client has an Enterprise license, so Enterprise only will do nicely.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
I have the more important ones on the top of my head. Is that helpful? :)
0
 
LVL 65

Author Comment

by:Jim Horn
Comment Utility
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
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 500 total points
Comment Utility
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
 
LVL 65

Accepted Solution

by:
Jim Horn earned 0 total points
Comment Utility
Just received this from a Microsoft employee buddy of mine ... Compare SQL Server versions
1
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Cool.
Thanks for sharing, Jim.
0
 
LVL 17

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
@Author - please let me know if you need more cheat sheets.
0
 
LVL 65

Author Comment

by:Jim Horn
Comment Utility
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
 
LVL 17

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
@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
 
LVL 65

Author Comment

by:Jim Horn
Comment Utility
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
 
LVL 65

Author Comment

by:Jim Horn
Comment Utility
Pawan - Please refrain from closing my questions.  I'd like to keep this open to see if any new information trickles in.
0
 
LVL 17

Expert Comment

by:Pawan Kumar Khowal
Comment Utility
No problem sir !! Going forward will keep that mind.

Bye,
Pawan
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now