Source links:
- Editions and supported features of SQL Server 2017
- Features Supported by the Editions of SQL Server 2017
- Features Supported by the Editions of SQL Server 2016
- Features Supported by the Editions of SQL Server 2014
- Features Supported by the Editions of SQL Server 2012
- Features Supported by the Editions of SQL Server 2008
- Features Supported by the Editions of SQL Server 2005
- SQL Server 2017 Pricing
- Azure SQL Database pricing
- An Overview of SQL Server 2016 Licensing
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.
| 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 |