Many New Features have been provided with the New SQL Server 2014. Microsoft SQL Server 2014 brings to market, new in-memory capabilities built into the core database, and provides new cloud capabilities to simplify cloud adoption for your SQL databases and help you unlock new hybrid scenarios. In this Blog I had provided these features in the way of difference between the older and New version of SQl Server.

 

New features or changes to existing features in Microsoft SQL Server 2014.

  • Memory-optimized Tables.  will help you quickly analyze your tables and walks you through reviewing and migrating disk-based table to In-Memory OLTP tables.
  • SQL Server Backup to URL
  • Encryption for Backups
  • New Design for Cardinality Estimation
  • Delayed Durability
  • AlwaysOn Enhancements
  • Business Intelligence Enhancement

The older version 2005, 2008 and 2012

  • SQL Server AlwaysOn. A high availability solution that increases application availability while also lowering total cost of ownership and making it easier to use.
  • Contained Databases, which intends to reduce or eliminate the dependencies that a database has on the SQL Server instance, making it easier to migrate a database to a new instance with less of the work involved in reproducing and validating these dependencies.
  • Web Development and Business Intelligence Enhancements. While business intelligence features were upgraded in SQL Server 2008 R2, Microsoft really improved Excel PowerPivot by adding more drill and KPI through.
  • ColumnStore Indexes. What a ColumnStore index does is essentially turn a traditional index on its side.
  • SQL 2008 also allows you to disable lock escalation on specific tables.
  • Transparent Database Encryption.  The ability to encrypt an entire database without having to change any code in your application adding an additional layer to your data security.
  • Intellisense in SQL Server Management Studio. Interactive help as you type giving object names and syntax support similar to Visual Studio.
  • In SQL 2005, even with the ROWLOCK hint on delete statements locks can be escalated which can lead to deadlocks. In my testing, an application which I have developed had concurrency issues during small table manipulation due to lock escalation on SQL 2005. In SQL 2008 this problem went away.

The new features are really great and its meets the very important factors of current age. For .Net people it's always be a boon to use SQL Server, I hope using the latest version we will have better security and better performance as well as the introduction of compression the size of the database. The backup encryption utility is also phenomenon.
Once again thanks to Microsoft for their great thoughts in form of software.