| Features | Enterprise | Business Intelligence | Standard |
|---|
| Maximum Number of Cores | OS Max¹ | 16 Cores-DB OS Max-AS&RS² | 16 Cores |
| Basic OLTP | checked | checked | checked |
| Programmability (T-SQL, Data Types, FileTable) | checked | checked | checked |
| Manageability (SQL Server Management Studio, Policy-based Management) | checked | checked | checked |
| Basic High Availability³ | checked | checked | checked |
| Basic Corporate BI (Reporting, Analytics, Multidimensional Semantic Model, Data Mining) | checked | checked | checked |
| Basic Data Integration (Built-in Data Connectors, Designer Transforms) | checked | checked | checked |
| Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)⁴ | checked | checked | |
| Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPaq™ In-Memory Engine, Advanced Data Mining) | checked | checked | |
| Enterprise Data Management (Data Quality Services, Master Data Services) | checked | checked | |
| Advanced Data Integration (Fuzzy Grouping and Lookup, Change Data Capture) | checked | | |
| Advanced Security (SQL Server Audit, Transparent Data Encryption) | checked | | |
| Data Warehousing (ColumnStore Index, Compression, Partitioning) | checked | | |
| Advanced High Availability (Multiple, Active Secondaries; Multi-site, Geo-Clustering)³ | checked | | |