| Always Encrypted |
Yes - see Cert store and Key vault |
| AlwaysOn Availability Groups |
No - see Failover groups and active geo-replication |
| Attach a database |
No |
| Application roles |
Yes |
| BACPAC file (export) |
Yes - see SQL Database export |
| BACPAC file (import) |
Yes - see SQL Database import |
| BACKUP command |
No - see Automated backups |
| Built-in functions |
Most - see individual functions |
| Change data capture |
No |
| Change tracking |
Yes |
| Collation statements |
Yes |
| Columnstore indexes |
Yes - Premium edition only |
| Common language runtime (CLR) |
No |
| Contained databases |
Yes |
| Contained users |
Yes |
| Control of flow language keywords |
Yes |
| Cross-database queries |
Partial - see Elastic queries |
| Cursors |
Yes |
| Data compression |
Yes |
| Database mail |
No |
| Database mirroring |
No |
| Database configuration settings |
Yes |
| Data Quality Services (DQS) |
No |
| Database snapshots |
No |
| Data types |
Yes |
| DBCC statements |
Most - see individual statements |
| DDL statements |
Most - see individual statements |
| DDL triggers |
Database only |
| Distributed transactions - MS DTC |
No - see Elastic transactions |
| DML statements |
Most - see individual statements |
| DML triggers |
|
| DMVs |
Some - see individual DMVs |
| Event notifications |
No - see Alerts |
| Expressions |
Yes |
| Extended events |
Some - see individual events |
| Extended stored procedures |
No |
| Files and file groups |
Primary file group only |
| Filestream |
No |
| Full-text search |
Third-party word breakers are not supported |
| Functions |
Most - see individual functions |
| Graph processing |
Yes |
| In-memory optimization |
Yes - Premium edition only |
| JSON data support |
Yes |
| Language elements |
Most - see individual elements |
| Linked servers |
No - see Elastic query |
| Log shipping |
No - see Failover groups and active geo-replication |
| Master Data Services (MDS) |
No |
| Minimal logging in bulk import |
No |
| Modifying system data |
No |
| Online index operations |
Supported - transaction size limited by service tier |
| Operators |
Most - see individual operators |
| Point in time database restore |
Yes - see SQL Database recovery |
| Polybase |
No |
| Policy-based management |
No |
| Predicates |
Most - see individual predicates |
| R Services |
Preview release; see What's new in machine learning |
| Resource governor |
No |
| RESTORE statements |
No |
| Restore database from backup |
From built-in backups only - see SQL Database recovery |
| Row Level Security |
Yes |
| Semantic search |
No |
| Sequence numbers |
Yes |
| Service Broker |
No |
| Server configuration settings |
No |
| Set statements |
Most - see individual statements |
| Spatial |
Yes |
| SQL Server Agent |
Nos- see Elastic jobs |
| SQL Server Analysis Services (SSAS) |
No - see Azure Analysis Services |
| SQL Server Auditing |
No - see SQL Database auditing |
| SQL Server Integration Services (SSIS) |
No - see Azure Data Factory |
| SQL Server PowerShell |
Yes |
| SQL Server Profiler |
No - see Extended events |
| SQL Server Replication |
Transactional and snapshot replication subscriber only |
| SQL Server Reporting Services (SSRS) |
No |
| Stored procedures |
Yes |
| System stored functions |
Some - see individual functions |
| System stored procedures |
Some - see individual stored procedures |
| System tables |
Some - see individual tables |
| System catalog views |
Some - see individual views |
| Table partitioning |
Yes - primary filegroup only |
| Temporary tables |
Local and database-scoped global temporary tables only |
| Temporal tables |
Yes |
| Variables |
Yes |
| Transparent data encryption (TDE) |
Yes |
| Windows Server Failover Clustering |
No - see Failover groups and active geo-replication |
| XML indexes |
Yes |
