Microsoft SQL Server Edition

Source links:

Microsoft SQL Server 2016 Edition

SQL Server 2016 is available in an Evaluation edition for a 180-day trial period. For more information, see the SQL Server 2016 Official page.

  • SQL Server 2016 Enterprise Edition – Core licensing only
  • SQL Server 2016 Standard Edition – Core or Server + CAL (Client Access License) licensing
  • SQL Server 2016 Express Edition - Free
  • SQL Server 2016 Developer Edition - Free
  • SQL Server 2016 Evaluation Edition – 180 day trial

The Developer edition has the same feature set as the Enterprise edition. It is completely free and can be run on any number of devices, but it cannot be used for production workloads. You can get it at SQL Server 2016 Developer edition. In contrast, the SQL Server 2016 Express editions can be used for production workloads, but they are limited to a single CPU and four cores, 1 GB of RAM (4 GB for the SQL Server 2016 Express with Advanced Services for Reporting Services). There is also a 10 GB per databases limitation.

Microsoft SQL Server 2014 Edition

Features Enterprise Business Intelligence Standard Express
Maximum number of cores OS Max 16 cores-DBOS Max-AS&RS2 16 cores 4 cores
Maximum memory utilized per instance OS Max 128 GB 128 GB 1 GB
Maximum size 524 PB 524 PB 524 PB 10 GB
Programmability (T-SQL, data types, FileTable) Yes Yes Yes Yes
SQL Server Management Studio Yes Yes Yes Yes
Policy-based management Yes Yes Yes No
Basic OLTP Yes Yes Yes Yes
Basic security (Separation of duties, basic auditing) Yes Yes Yes Yes
Basic high availability Yes Yes Yes No
Built-in data connectors Yes Yes Yes Yes
Basic data integration (SSIS, designer transforms) Yes Yes Yes No
Basic reporting Yes Yes Yes Yes
Basic corporate BI (Analytics, multidimensional semantic model, data mining) Yes Yes Yes No
Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server) Yes Yes No No
Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining) Yes Yes No No
Enterprise data management (Data Quality Services, Master Data Services) Yes Yes No No
Advanced data integration (Fuzzy grouping and lookup, change data capture) Yes No No No
Advanced security (SQL Server audit, transparent data encryption) Yes No No No
Data warehousing (In-memory columnstore, compression, partitioning) Yes No No No
Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering) Yes No No No
Advanced transaction processing (In-memory OLTP) Yes No No No