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 your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
 

COMMENTS powered by Disqus  //  Commenting policy