Performance
Enhanced in-memory performance with upto 30xfaster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics.
Security Upgrades
Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without any application changes.
High Availability
Even higher availability and performance than SQL Server 2014 with AlwaysOn secondaries with the ability to have up to 3 synchronous replicas, DTC support and round-robin load balancing of the secondaries.
Scalability
Enhanced database caching across multiple cores & support for Windows Server 2016 that efficiently scale compute, networking and storage in both physical and virtual environments.
|
|
Access Any Data
Query relational and
non-relational data with the simplicity of T-SQL with PolyBase. Manage document data with native JSON support.
Scale and Manage
Enhanced performance, scalability and usability across SQL Server Enterprise Information Management tools and Analysis Services.
Powerful Insights on any device
Business insights through rich visualizations on mobile devices. Native apps for Windows, iOS and Android. New modern reports for all browsers.
Advanced Analytics at massive scale
Built-in advanced analytics provide the scalability and performance benefits of running your “R” algorithms directly in SQL Server. Expand your analytics library with Microsoft Azure Marketplace. |
|
Breakthrough hybrid scenarios
Stretch Database technology keeps more of your customers’ historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure on-demand without application changes.
Simplicity
New tools that make SQL Server migration to Microsoft Azure and hybrid scenarios even easier.
Consistency
Consistent experience from on-premises to Microsoft Azure IaaS & PaaS. |
