- Always Encrypted
The main purpose of the function Always Encrypted is protecting data, either during transmission or at rest. Thanks to this feature, SQL Server manages the encrypted data and encryption key may be stored along with the application. Encryption and decryption of data are performed transparently inside the application. This means that stored in the SQL Server data is encrypted. This may protect them from the database administrator and system administrators, as well as it plays a role in execution of non-regulated requests, working with reports and exporting data.
- Stretch Database
The idea underlying this technology is of undoubted interest. Function Stretch Database gives the ability to accommodate dynamically the local database on the Azure platform. And it allows to leave frequently used “hot” data on local equipment but to move to the cloud infrequently used (“cold”) data. Thus, you retain the benefits of using low-cost means of data storage in Azure and work with high-performance applications. However Microsoft must make every effort to separate the requests. They should not “enter” in the cloud, because in this case all the previously obtained performance gain will come to naught. Though this connective is not so reliable so antivirus program will have to use.
- Real-time Operational Analytics
This function embodies the dynamic duet of SQL Server technologies, implementing in-memory transaction. It combines the processing technology of In-Memory OLTP and in-memory columnstore, which allows to perform operational analytics in real time. The purpose of this function is to configure the system for optimal performance of transactions and to increase the degree of parallelism workloads. Apparently, it is a great combination, and the use of analytics to this indicator as the performance of the system is the long-awaited option for many consumers. However, in order to use the advantages of this solution, you will need sufficient memory.
- PolyBase в SQL Server
The strategic importance of Big Data continues to grow, but if you do not have a hardware-software complex for data storage and parallel processing of critical data SQL Server Parallel Data Warehouse (PDW), SQL Server connection to the complexes of Big Data, first of all to sets Hadoop would be fraught with difficulties. In previous versions PDW was the only version of SQL Server equipped with PolyBase technology, which served as a kind of bridge between SQL Server and Hadoop. It gave the opportunity to create and execute SQL requests in Hadoop data warehouses, saving the operator from having to understand the intricacies of HDFS or MapReduce. So SQL Server 2016 will attach the basic technologies of PolyBase to major version of SQL Server.
- Support for JSON
- Enhancements of AlwaysOn
In SQL Server 2016 which requires a reliable Internet connection, means to ensure high availability and recovery after a crash will be further developed. We are talking about several improvements of AlwaysOn tools. These tools are endowed with the ability to have up to three synchronous replicas. In addition, they are compatible with the service Distributed Transaction Coordinator (DTC) and may provide a cyclic scheme of balancing the loads on the secondary replica. The support for automatic emergency switch at infringement of working capacity of databases implemented in the product.
- Improved mechanism of performing transaction In-Memory OLTP
First implemented in SQL Server 2014, this mechanism will reach a new level of maturity in SQL Server 2016. Microsoft specialists will distribute the functionality of In-Memory OLTP for a greater number of applications and increase the level of parallelism. They will expand the scope of T-SQL will bring the supported memory up to a terabyte and will increase the number of supported processors.
- Partially upgraded set of tools SQL Server Data Tools
Another successful change in SQL Server 2016 is the re-consolidation of a set of tools SQL Server Data Tools (SSDT). In the process of working on SQL Server Data Tools, designed to replace popular and useful Business Development Studio (BIDS), Microsoft experts eventually proposed a solution that baffled almost all consumers. They created two versions of SQL Server Data Tools. Moreover, one and the other need be downloaded separately, outside the context of actually installing SQL Server. Releasing SQL Server 2016, Microsoft has signaled that it intends to merge SQL Server Data Tools.