| Features | Enterprise | Business
Intelligence |
Standard |
| Maximum Number of Cores | OS Max¹ | 16 Cores-DB
OS Max-AS&RS² |
16 Cores |
| Basic OLTP |
X |
X |
X |
| Programmability (T-SQL, Data Types, FileTable) |
X |
X |
X |
| Manageability (SQL Server Management Studio, Policy-based Management) |
X |
X |
X |
| Basic High Availability³ |
X |
X |
X |
| Basic Corporate BI (Reporting, Analytics, Multidimensional Semantic Model, Data Mining) |
X |
X |
X |
| Basic Data Integration (Built-in Data Connectors, Designer Transforms) |
X |
X |
X |
| Self-Service Business Intelligence (Alerting, Power View, PowerPivot for SharePoint Server)4 |
X |
X |
|
| Advanced Corporate BI (Tabular BI Semantic Model, Advanced Analytics and Reporting, VertiPaq™ In-Memory Engine, Advanced Data Mining) |
X |
X |
|
| Enterprise Data Management (Data Quality Services, Master Data Services) |
X |
X |
|
| Advanced Data Integration (Fuzzy Grouping and Lookup, Change Data Capture) |
X |
||
| Advanced Security (SQL Server Audit, Transparent Data Encryption) |
X |
||
| Data Warehousing (ColumnStore Index, Compression, Partitioning) |
X |
||
| Advanced High Availability (Multiple, Active Secondaries; Multi-site, Geo-Clustering)³ |
X |
¹Existing SQL Server Enterprise edition licenses in the Server + CAL licensing model upgraded to SQL Server 2012 will be limited to server deployments with 20 cores or less. Refer to Datasheet and FAQ for more details.
²Analysis Services & Reporting Services.
³Basic includes log shipping, database mirroring, server core support and two-node Failover Clustering. Windows Server Enterprise edition or above is a system requirement for AlwaysOn / Failover Clustering.
4SharePoint Server with Enterprise CAL is a system requirement for Power View and PowerPivot for SharePoint. Alerting is accessible through SharePoint Foundation or above.