Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2016-09-09
15
Medium Priority
?
137 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 3
  • +1
15 Comments
 
LVL 44

Expert Comment

by:zephyr_hex (Megan)
ID: 41791934
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 66

Author Comment

by:Jim Horn
ID: 41791967
Client has an Enterprise license, so Enterprise only will do nicely.
0
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41793848
I have the more important ones on the top of my head. Is that helpful? :)
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 66

Author Comment

by:Jim Horn
ID: 41794374
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 52

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 2000 total points
ID: 41794441
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 66

Accepted Solution

by:
Jim Horn earned 0 total points
ID: 41796421
Just received this from a Microsoft employee buddy of mine ... Compare SQL Server versions
1
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 41797363
Cool.
Thanks for sharing, Jim.
0
 
LVL 32

Expert Comment

by:Pawan Kumar
ID: 41801230
@Author - please let me know if you need more cheat sheets.
0
 
LVL 66

Author Comment

by:Jim Horn
ID: 41801711
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 32

Expert Comment

by:Pawan Kumar
ID: 41801751
@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 66

Author Comment

by:Jim Horn
ID: 41801759
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 66

Author Comment

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

Expert Comment

by:Pawan Kumar
ID: 41826409
No problem sir !! Going forward will keep that mind.

Bye,
Pawan
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

610 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