SQL Server 2014 – What are the new features in MS SQL 2014?

Microsoft’s SQL Server 2014 was released to the public on April 1 2014. This version of SQL Server has quite a few new features, the biggest one is by far the In-Memory OLTP engine that makes performance boost by up to 20x times. Get the latest version of SQL Server 2014 here:

Noteworthy product features as announced include the following,

  1. The MS SQL 2014 enhances mission-critical support for the enterprise applications. These cover extended in-memory processing capabilities, including in-memory OLTP, higher performance, increased availability and manageability of the mission-critical applications. Enhancements in query processing helps.
  2. SQL Server 2014 backup solutions in the cloud are through Microsoft’s Azure service; business continuity solutions in case of disasters are offered.
  3. Enhancements in scalability and security are available on the MS SQL Server 2014 version.
  4. Higher availability is ensured and enhanced in the product.
  5. Performance increase of 10 to 50 times of your existing applications can be expected.
  6. Big data support is built-in and helps get insight into big and small data, including un-structured ones. 
  7. Self service BI tools introduced in 2012 version are enhanced in SQL Server 2014 for quicker business intelligence gathering.
  8. A complete Business Intelligence solution is offered that lets you scale the model and secure it at the same time. You could easily obtain quality and accuracy of your BI truths. Power Query and Power Map features in Excel processing help enhance the BI capabilities in SQL Server 2014.
  9. The Microsoft SQL Server 2014 also offers means of implementing a hybrid on-premises and cloud solutions for the most optimal IT solutions.

Some of the limitations indicated for the CTP1 version of the SQL Server 2014 are listed below.

  • The SQL Server 2014 CTP1 will not be supported by Microsoft’s customer service. Support from the community is all that is available.
  • This version is 64 bit only for the time being. 
  • This SQL Server 2014 CTP1 is only for evaluation and should not be used in production environment. In fact, it is suggested that the software should be installed in a clean machine.
  • The MS SQL 2014 CTP1 will not support upgrade from earlier releases or work side by side with earlier versions, including the latest 2012 version. Visual studio, SQL Server data tools and application framework too will not work with this CTP release.
  • SQL Server Management Studio that is shipped with the product should only be used to manage the database system.
  • The Azure virtual machine software can be used for development and testing. Performance testing cannot be supported.

Downloading of the product and installation is easy. There is only one downloadable package at the site so simply download and install it. The installation is straightforward too. If you are from the early adopter community, this will give you an opportunity to get a good feel of the SQL 2014 version early on. By the time the production version comes along, you could be completely ready for moving your production applications to the new platform that is faster, more secure and has higher availability. If you want to learn more check out our SQL Server 2014 tutorials.

Check out these links as well:


Follow us on: