SQL Series Part 2 : SQL Server 2016 Editions

Onur Dogruoz




Whenever we introduce new version of SQL Server, we are getting a lot questions about the edition line up and licensing changes. From editions perspective, SQL Server 2016 is very similar to 2014 version. We will continue to have Enterprise, Standard, Express and Developer editions as mainstream options. Only change is; Business Intelligence edition will no longer be an option.


Like all previous versions, with Enterprise edition, our customers will benefit from low cost of ownership with the full capabilities of SQL Server built into a single offering including our mission critical database, high performance data warehouse, rich data integration capabilities, end-to-end mobile business intelligence, built-in advanced analytics and virtualization benefits.


SQL Server 2016 Standard edition will continue to deliver tremendous value. It includes enhanced performance with basic availability, greater scalability up to 24 cores, modern reports, tabular modeling capabilities and, my favorite, robust security and hybrid cloud capabilities. We will touch on some of these key capabilities like Stretch Database, Dynamic Data Masking and Row-Level Security in the following posts.


Express edition will continue to be available as a free download, for small scale database applications at no cost.


In addition to Enterprise, Standard and Express editions, Developer edition provides access to the full capabilities of SQL Server to build and test new mission critical, intelligent applications. Please keep in mind, Developer edition is only for development and test environments and should not be used in production. And lastly, if you have missed the announcement, SQL Server Developer Edition is now a FREE download for Visual Studio Dev Essentials members.


You can download the SQL Server 2016 Editions Datasheet here




Happy selling!

Skip to main content