Microsoft delivers in-memory OLTP in SQL Server 2014 - What’s new in SQL Server 2014

What’s new in SQL Server 2014

Microsoft delivers in-memory OLTP in SQL Server 2014

1 of 6
sql-server-2014.jpg Source: Microsoft

Microsoft released SQL Server 2014 in April 2014. The new release includes an in-memory database engine (code named Hekaton) called in-memory OLTP, which also includes stored procedures compiled to native code.

This can greatly speed performance, though compatibility issues mean it requires some porting work to take advantage. There is also new integration with Azure, Microsoft’s cloud platform, which offers small businesses easy backup and large businesses new options for high availability and scaling. Data warehouse users benefit from new updateable columnstore indexes.

The rest of SQL Server is little changed, a fact which does not lessen the significance of the new database engine features, but which does suggest that those who cannot use them will be in no hurry to upgrade.

1 of 6

More from this story

Email Alerts

Register now to receive ComputerWeekly.com IT-related news, guides and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
 

COMMENTS powered by Disqus  //  Commenting policy