Build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in—from in-memory performance and advanced security to in-database analytics.
The editions are offered in a straightforward, tiered model that creates greater consistency across the product editions, features and licensing. Enterprise Edition includes all the capabilities available in SQL Server 2019.
Through a consistent programming interface across all editions, it is easier than ever for developers and partners to build and upgrade applications that take advantage of advanced performance, security, and data mart or data warehouse features – regardless of scale, from Express to Enterprise.
SQL Server is offered in two main editions to accommodate the unique feature, performance and price requirements of organizations and individuals:
SQL Big Data Nodes are licenses assigned to worker nodes in big data environments, and are licensed under Enterprise Edition use rights.
SQL Server edition
Server + Client Access License (CAL) 3 Per Core license 21. Customers who require a massively parallel processing data warehouse have access to a parallel data warehouse through their Enterprise Edition core licenses with Software Assurance. Parallel data warehouse is part of the Microsoft Analytics Platform System.
2. Editions sold in the per-core licensing model and Big Data Nodes are sold as 2 core packs.3. Client access licenses (CALs) are required for every user or device accessing a server in the Server + CAL licensing model. See the Product Terms for details.
SQL Server 2019 brings Big Data Clusters to the SQL offering. Big Data Clusters make it easier for customers to manage a big data environment. Software Assurance customers are eligible for a grant of SQL Server Big Data Node Licenses for use with licenses assigned to their Master Nodes. SQL Server 2019 also brings expanded fail-over rights to Software Assurance customers supporting disaster recovery and high availability. For details refer to the Product Terms site.
Enterprise and Standard are the two main editions. The Web Edition is offered only to hosters through the Services Provider License Agreement (SPLA). Developer and Express editions continue to be distributed without changes in licensing or pricing. We also offer the Analytics Platform System appliance, which includes SQL Server Parallel Data Warehouse software as a component.
Yes. All existing licenses of the Enterprise Edition in the Server + CAL licensing model with Software Assurance can be upgraded to the latest version of SQL Server, and Software Assurance can be maintained to provide access to future software updates. These licenses will continue under the Server + CAL licensing model.
Existing Enterprise Edition licenses in the Server + CAL licensing model that are upgraded to the current version of SQL Server and beyond are limited to server deployments with 20 or fewer cores. This 20-core limit applies only to SQL Server Enterprise Edition Server licenses in the Server + CAL model and still requires the appropriate number/versions of SQL Server CALs for access.