Yesterday New Horizons in Fort Lauderdale asked me to present to some of their customers on SQL 2012 and and 2014, focusing in on the new features most essential to know. You can find the slides in the Presentations link above.
The presentation was only 3 hours, so I really struggled with what to cover, and I boil down the most important features to these:
- AlwaysOn in SQL 2012/2014
- Clustered ColumnStore Indexes in SQL 2014 (2012 has Non Clustered ColumnStore Indexes only)
- In-Memory OLTP in SQL 2014
Yes, I talked about DQS,MDS,Tabular,SSIS Project Model, T-SQL Enhancements, Azure options, and some other cool features. But the three above are, in my opinion, the most important.
Disagree with me? Let me know your opinion in a comment or by contacting me!