SQL Server CTP2 Release

SQL Server CTP2 officially released on May 29

Community Technology Preview (Community Technology previews) is for testing purposes only and should not be installed and used in a production environment. When you install the official version in a production environment, you are forced to uninstall all CTP versions of this computer first.

The CTP program is a strategy for Microsoft to build a new image, CTP plans to use an "early release, often released" way to enable users to more timely practical testing software, create a separate "feature crews (functional group)", you can quickly create a specific function, and for these features directly with the user communication.

Here is the official website of SQL Server 2016 to explain the new features, I simply translated.

http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/ Sql-server-2016-public-preview-coming-this-summer.aspx? Wt.mc_id=blog_sql_announce_di

First, the whole process of encryption

The first thing to mention is data security. When SQL Server is running on the on-premises or "cloud" side, the "Full Encryption" feature will help customers resolve data security issues.

650) this.width=650; "title=" full encryption. png "alt=" wkiol1wq3jpycfefaacuq7_ro7a709.jpg "src=" http://s3.51cto.com/wyfs02/ M02/6f/0c/wkiol1wq3jpycfefaacuq7_ro7a709.jpg "/>

"Full Encryption" is based on Microsoft Research, which protects data both statically and dynamically. With "full encryption", SQL Server can manipulate the encrypted data first, while the encryption key exists in the application in the user's trusted environment. Data encryption and decryption can minimally modify existing applications, to maximize the security of the user's data.

Ii. extension of the database

Today, customers will benefit from a hybrid scenario that includes a large scale "cloud" of "stretched databases". The table for core transactions needs to grow, and you may need to archive historical data to low-cost areas to maintain better performance.

650) this.width=650; "title=" extension database. jpg "alt=" wkiol1wq4ektfcyuaabc__8qh0c925.jpg "src=" http://s3.51cto.com/wyfs02/ M02/6f/0c/wkiol1wq4ektfcyuaabc__8qh0c925.jpg "/>

This new technology dynamically extends "hot" and "cold" transactional data to Microsoft Azure for easy viewing anywhere, and you can benefit from the low cost of Microsoft Azure. Alternatively, you can encrypt the data using "full encryption".

Third, real-time business analysis and memory OLTP

For memory OLTP, customers can now implement transactions that are 30 times times faster than previous disk-based systems. These enhancements, together with memory Columnstore, provide up to 100 times times the query speed on memory OLTP to provide real-time business analytics and speed transaction performance.

650) this.width=650; "title=" Memory Oltp.png "alt=" wkiom1wq4jmcf7yiaacwaezxtee816.jpg "src=" http://s3.51cto.com/wyfs02/ M00/6f/10/wkiom1wq4jmcf7yiaacwaezxtee816.jpg "/>

Iv. built-in advanced analytics, basic strategy for mobile BI

For insight into data, SQL Server 2016 provides advanced analytics beyond the realm of transaction processing, data warehousing, and business intelligence. This feature becomes a new workload for SQL Server through the mature Revolution Analytics technology.

650) this.width=650; "Title=" advanced analysis. jpg "alt=" wkiol1wq5cigl1hvaacysn7lize805.jpg "src=" http://s3.51cto.com/wyfs02/ M00/6f/0c/wkiol1wq5cigl1hvaacysn7lize805.jpg "/>

In addition, we have established a baseline policy in SQL Server that extends the ability to extract value from unstructured and structured data through existing T-SQL technologies. So you can get insights faster from the rich image of mobile devices (Windows,ios and Android).

650) this.width=650; "title=" Move Bi.jpg "alt=" wkiol1wq5era4oduaab3xgl4tci420.jpg "src=" http://s3.51cto.com/wyfs02/ M01/6f/0c/wkiol1wq5era4oduaab3xgl4tci420.jpg "/>

V. Other new features

More new features of SQL Server 2016 include:

Enhanced security: Provides row-level security (row-level Security) and Dynamic Data masking (masking) with "full Encryption"

AlwaysOn enhancements: Enables more robust high availability and disaster recovery, including multiple synchronous replication, replica load balancing;

Native JSON support: better performance, support for various types of data.

SQL Server Enterprise Information Management (EIM) tools and analytics services: Improved performance, availability, scalability

Fast hybrid backup, high availability, and disaster recovery scenarios: Back up and restore the local database to Azure thereby deploying SQL Server AlwaysOn Secondary replicas in Azue.

This article is from the "We have chased the MSSQL" blog, please be sure to keep this source http://jimshu.blog.51cto.com/3171847/1668991

SQL Server CTP2 Release