SQL Server 2012

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.