It's simple please go through below link to download free, nowadays Microsoft giving Developer edition free download, because they love developers and you get all feature whatever you get in the enterprise version, soo cool right, but only one catch you can't use developer for your production environment.
Please find the difference in below table.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
| Features | SQL Server 2016 Enterprise | SQL Server 2016 Standard | SQL Server 2016 Express | SQL Server 2016 Developer |
| Maximum number of cores | Unlimited | 24 Cores | 4 Cores | Unlimited |
Maximum memory utilized per instance |
Operating system max | 128 GB | 1 GB | Operating system max |
Maximum size |
524 PB | 524 PB | 10 GB | 524 PB |
Production use rights |
Yes | Yes | Yes | No |
Basic OLTP |
Yes | Yes | Yes | Yes |
Manageability: Management Studio, policy-based management |
Yes | Yes | Yes | Yes |
Basic high availability: 2-node single database failover, non-readable secondary |
Yes | Yes | NO | Yes |
Enterprise data management: Master Data Services, Data Quality Services |
Yes | NO | NO | Yes |
Advanced OLTP: In-memory OLTP, operational analytics |
Yes | NO | NO | Yes |
Advanced High Availability: Always On Availability Groups, multi-database failover, readable secondaries |
Yes | NO | NO | Yes |
Basic security: Row-level security, data masking, basic auditing, separation of duties |
Yes | Yes | NO | Yes |
Advanced security: Transparent database encryption, Always Encrypted |
Yes | No | NO | Yes |
Advanced data integration: Fuzzy grouping and lookups, change data capture |
Yes | NO | NO | Yes |
Data warehousing: In-Memory Columnstore, partitioning |
Yes | No | NO | Yes |
PolyBase2 |
Yes | Yes | NO | Yes |
Maximum memory utilized per instance of Analysis Services |
Operating system max | Tabular: 16 GB MOLAP: 64 GB |
No | NO |
Maximum memory utilized per instance of Reporting Services |
Operating system max | 64 GB | Express with Advanced Services: 4 GB |
NO |
Programmability and developer tools: T-SQL, CLR, Data Types, FileTable, JSON |
Yes | Yes | Yes | Yes |
Basic reporting and analytics |
Yes | Yes | No | Yes |
Basic data integration: SQL Server Integration Services, built-in connectors |
Yes | Yes | No | Yes |
Basic corporate business intelligence: Basic multi-dimensional models, basic tabular model, in-memory storage mode |
Yes | Yes | No | Yes |
Mobile reports and KPIs |
Yes | No | NO | Yes |
Advanced corporate business intelligence: Advanced multi-dimensional models, advanced tabular model, DirectQuery storage mode, advanced data mining |
Yes | NO | NO | Yes |
Basic R integration: Connectivity to R open, limited parallelism |
Yes | Yes | Yes | Yes |
Advanced R integration: Full parallelism ScaleR |
Yes | NO | NO | Yes |
Hybrid cloud Stretch Database |
Yes | Yes | Yes | Yes |
If you have any questions, please comment below, I will try to reply back ASAP
No comments:
Post a Comment