SQLServer2014 preview edition displays in-Memory Database Technology

At this year's TechEd conference, Microsoft announced the first technical preview version of SQLServer2014, which will be officially available for download this month. The official release date of the product is initially set at the end of this year. The biggest highlight of the new version is the table-level memory OLTP (On-LineTransactionProcessing, online transaction processing system) and the provision of real-time big data

At this year's TechEd conference, Microsoft announced the first technical preview version of SQL Server 2014, which will be officially available for download this month. The official release date of the product is initially set at the end of this year. The biggest highlight of the new version is the table-level memory OLTP (On-Line Transaction Processing, online Transaction Processing system) and the provision of real-time big data

At this year's TechEd conference, Microsoft announced the first SQL Server 2014TechnologyThe preview version will be officially available for download this month, and the official release date of the product is initially set at the end of this year. The biggest highlight of the new version is the table granularity level.MemoryOLTP (On-Line Transaction Processing, online Transaction Processing system) and provides real-time big data analysis functions.

Quentin Clark, vice president of Microsoft enterprise responsible for the project, said,MemoryOLTP is derived from the Hekaton that Microsoft has used for many years.MemoryTransaction type inDatabaseEngine, and this project will be fully included in SQL Server 2014. In terms of performance, it is 50 times higher than the current standard SQL Server.

　　SQL Server function evolution

Clark also said that Microsoft will provide the HeakatonMemoryOLTP, for users, "In the box" means users can use it in projects without buying special software/hardware support.MemoryOLTP function.

Another highlight of this version is the capability of the hybrid cloud platform, which claims to simplify cloud backup and disaster recovery by backing up to Azure and connecting to Azure at any time, in addition, it is easy to migrate automatically deployed SQL servers to Azure virtual machines.

In actual development, the SQL Server team will continue to invest in R & D and investment in columnstore performance and data compression. Currently, column store has been rooted in BI services and Excel tools for faster business observation.

For more information about SQL Server 2014, go to the SQL Server blog.

Original article from: I-programmer