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.