What’s new in SQL Server 2014?
Breakthrough performance with In-Memory OLTP
- In-Memory OLTP: In-memory transaction processing (In-Memory OLTP) speeds up an already very fast experience by delivering speed improvement of up to 30x. Important to our in-memory work is our approach to build SQL Server’s In-Memory OLTP right into the box. This means our you don’t need expensive additional software to take advantage of the technology. More importantly, it means customers do not have to rewrite their application or deploy new servers. SQL Server 2014 is the first database to have integrated In-Memory OLTP technology and SQL Server 2014 will have the most comprehensive in-memory offerings of leading enterprise vendors.
- Enhanced In-memory ColumnStore for Data Warehousing: Updatable, Faster, Better compression
- Resource governor adds IO governance: predictable performance
- Buffer Pool extensions to SSD: Faster paging
- Enhanced Query Performance: Faster performance without any apps changes
Hybrid Cloud for Disaster Recovery
- Simplified Cloud Back up: Now you can easily and securely backup and recover on-premises SQL Server databases using Windows Azure.
- Disaster Recovery with Azure. SQL Server 2014’s AlwaysOn technology was not just improved for this release, it was built to enroll Windows Azure virtual machines running SQL Server into a disaster recovery solution. This turnkey solution builds on SQL Server 2014 availability in Windows Azure virtual machines – one can get SQL Server with its in-memory and mission-critical features up and running in an Azure VM in literally a few minutes.
> If you want access to the release as soon as possible, please sign-up to be notified once the release is available.
> Also, please join us on April 15 for the Accelerate Your Insights live event from San Francisco, California to learn about our data platform strategy and how our customers who already deployed the solution are gaining significant value with SQL Server 2014.
There also will be additional launch events. So please check this blog for announcements or contact your Microsoft representative and local PASS chapter for more information on SQL Server readiness opportunities.