Intelligence across all your data

Data virtualization using PolyBase

Database performance

In-memory database: in-memory OLTP

In-Memory Database: Persistent Memory

In-memory database: memory-optimized tempdb

Real-time operational analytics

Intelligent query processing

Intelligent performance

Availability

Always on

Accelerated database recovery

Read scale-out availability groups

Security

Always encrypted

Always encrypted with secure enclaves

Data discovery and classification

Transparent data encryption

Backup encryption support

Encryption at rest and in motion

Dynamic data masking and row-level security

Cloud readiness

Backup to Azure

Disaster recovery to Azure

Optimized virtual machine (VM) images in Azure gallery

Free asynchronous replication on Azure Virtual Machines for disaster recovery

Management and programmability

Linux support

Container support

Kubernetes support

Temporal tables

JSON support

Graph data support

UTF 8 support

Java support

Azure Data Studio to manage SQL Server including support for T-SQL using notebooks

Database compatibility certification

BI and Analytics Support

Integration services managed as a server

Tabular BI semantic model

Master data services

Data quality services

Many-to-many relationships in tabular models

End-to-end mobile BI on any device

SQL Server Analysis Services (SSAS) direct query

Calculation groups in tabular model