SQL Server and the data platform
SQL Server offers the right edition to meet your needs, including Enterprise for mission critical applications, enterprise business intelligence and data warehousing; Business Intelligence for self-service and corporate business intelligence; and Standard for basic database, reporting and analytics capabilities.Read the SQL Server 2014 and the Data Platform datasheet
|Maximum number of cores||OS Max||16 cores-DBOS Max-AS&RS3||16 cores||4 cores||OS Max|
|Maximum memory utilized per instance||OS Max||128 GB||128 GB||1 GB||OS Max|
|Maximum size||524 PB||524 PB||524 PB||10 GB||524 PB|
|Production use rights2|
|Programmability (T-SQL, data types, FileTable)|
|SQL Server Management Studio|
|Basic security (Separation of duties, basic auditing)|
|Basic high availability4|
|Built-in data connectors|
|Basic data integration (SSIS, designer transforms)|
|Basic corporate BI (Analytics, multidimensional semantic model, data mining)|
|Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server)|
|Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining)|
|Enterprise data management (Data Quality Services, Master Data Services)|
|Advanced data integration (Fuzzy grouping and lookup, change data capture)|
|Advanced security (SQL Server audit, transparent data encryption)|
|Data warehousing (In-memory columnstore, compression, partitioning)|
|Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering)|
|Advanced transaction processing (In-memory OLTP)|
1 Specifications are for SQL Server Express core. Learn more about embeddable Express LocalDB.
2 SQL Server 2014 Developer Edition offers the full feature set of SQL Server 2014 Enterprise Edition, but this edition is for development and test only, and not for production environments or use with production data. For additional detail about Developer Edition use rights, please see the Microsoft SQL Server 2014 Licensing Guide.
3 Analysis Services & Reporting Services.
4 Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.
5 Basic reporting is available in Express with Advanced Services.