SQL SERVER 2012 CAPABILITIES


SQL SERVER 2012 CAPABILITIES

The table below shows a feature comparison among the three main editions.

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

¹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.
SharePoint Server with Enterprise CAL is a system requirement for Power View and PowerPivot for SharePoint. Alerting is accessible through SharePoint Foundation or above.