Source links:
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.
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 |