What’s new in SQL Server 2014

1/6

Microsoft delivers in-memory OLTP in SQL Server 2014

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.

View All Photo Stories

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close