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.