MS SQL Server 2016

As a core of the Microsoft data platform, SQL Server is a leading operational database management system.

Performanace and Management

• Enhanced Database Caching
• Query data store
• In-Memory OLTP in SQL Server 2016

Development

• Temporal Database
• Temporary Table and Variable Table in-memory
• Native JSON

High Availability and Security

• Enhanced AlwaysOn
• Always Enrypted
• Row-level Security
• Dynamic Data Masking

Data Insight and Business Intelligence

• Operational Analytics
• New functionality Columnstore Index
• Direct Query in SSAS Tabular
• R Integration (language R in SQL Server)
• Enhanced SSIS
• Enhanced MDS

Reporting Services

• New Report Server
• Mobil Reports
• SQL Server Mobile Report Publisher

Cloud and Hybrid

• Stretch Database
• Enhanced backup to Azure
• Migration SQL Server to Azure
• SSIS and Data Factory