Query and analyze your data using industry-leading performance and security.
Provides the option to license users and/or devices, with low cost access to incremental SQL Server deployments.
Gives a more precise measurement of computing power and a more consistent metric, regardless of whether solutions are deployed on physical servers on-premises, or in virtual/cloud environments.
Download the full Microsoft SQL Server 2019 Licensing guide
|SQL Server 2019 New Features||Standard||Enterprise|
|Compute and storage||Maximum number of cores||24||OS Max|
|Maximum memory utilized per instance||128 GB||OS Max|
|Maximum size||524 PB||524 PB|
|Intelligence over all your data||SQL Server 2019 Big Data Clusters with Apache Spark and HDFS built into SQL Server engine|
|Data virtualization using PolyBase (including additional data sources like Oracle, Teradata, MongoDB, and other SQL Server databases)|
|Unified AI platform to train and operationalize models with SQL Server ML Services|
|Choice of language and platform||Compatibility certfication|
|Support for SQL Server Java extension|
|Industry-leading performance and availability||Free DR replicas in Azure and on-premises|
|Intelligent Query processing: Scalar UDF inlining, table variable deferred compilation, approximate count distinct|
|Intelligent Query processing features: row mode memory grant feedback, batch mode for row store and automatic tuning|
|Automatic read-write connection re-routing|
|In-Memory Database: memory-optimized tempdb|
|In-Memory Database: Persistent Memory support|
|Accelerated Database recovery|
|Secure and reliable||Always Encrypted with secure enclaves|
|Transparent database encryption|
|Data classification and auditing|
|Quick business insights||Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks|
|SQL Server Analysis Services Direct Query|
Microsoft SQL Server has been one of the premier leaders in database technology for years. The 2019 edition picks up right where it's predecessor left off. New to SQL Licensing? Check out our SQL Server licensing guide to find out the features that would benefit you and how license.
Take a deeper dive into SQL licensing with a licensing expert from our team in our Video Meetup below.
No page specified. To populate this tab, choose which page you wish to display in Theme Settings under the Product Pages heading.
This is exactly what I was looking for. Todd was so helpful in quoting me the right product for the best price!
Microsoft SQL Server 2019 Standard +10 CALs - License
Customer support and sales where excellent and gave fast and efficient service. Will definitely use again
I had no idea about both licensing models. They were really helpful in explaining both models to me and they guided me to the most cost-effective route for my deployment.
Consistent memory support is something that has made a substantial difference for myself.