Microsoft
Microsoft SQL Server 2019 Standard - License + 10 CALs
Microsoft SQL Server 2019 Standard - License + 10 CALs
Couldn't load pickup availability
Secure Your Data With SQL Server 2019
Query and analyze your data using industry-leading performance, security, and scalability for your relational database and data warehouse workloads.
How to License SQL Server Standard
Option #1
SERVER + CAL:
This SQL Server licensing option provides the flexibility to license users or devices with low-cost access to incremental SQL Server deployments.
- Each server running SQL Server software requires a server license.
- Each user or device accessing a licensed SQL Server requires a SQL Server CAL that is the same version or newer. For example, to access a SQL Server 2019 Standard license, a user needs a SQL Server 2019 CAL license.
- Each SQL Server CAL allows access to multiple licensed SQL Servers, including Standard Edition, legacy Business Intelligence, and Enterprise Edition Servers.
- Choose between User CALs or Device CALs based on your needs.
Option #2
The core-based licensing model gives a more precise measurement of computing power and a more consistent metric, regardless of whether you deploy solutions on physical servers on-premises or in virtual/cloud environments, such as Microsoft Azure.
- Core-based licensing is appropriate when customers are unable to count users/devices, have Internet/Extranet workloads, or have systems that integrate with external-facing workloads.
- To license a physical server—when running SQL Server in a physical operating system environment (OSE)—all physical cores on the server must be licensed.
- A minimum of a four core license is required for each SQL instance on the server.
Download the full Microsoft SQL Server 2019 Licensing guide
SQL Server Features: Standard vs. Enterprise
| 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 | ||||
| Azure Machine Learning and Spark ML | ||||
| Choice of language and platform | Compatibility certfication | |||
| UTF-8 Support | ||||
| 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 | ||||
| Support for Kubernetes deployment | ||||
| Secure and reliable | Always Encrypted with secure enclaves | |||
| Transparent database encryption | ||||
| Data classification and auditing | ||||
| Vulnerability assessment | ||||
| Quick business insights | Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks | |||
| SQL Server Analysis Services Direct Query | ||||
Key Features of SQL Server 2019 Standard Edition
- Enhanced database management system functionality
- Support for big data clusters (HDFS and Spark integration)
- Advanced machine learning (ML) and artificial intelligence (AI) capabilities
- High availability and multiple disaster recovery options
- Improved compatibility with a broader range of workloads
- Virtualization support
Operating System Compatibility
SQL Server 2019 is compatible with Microsoft Windows Server and Linux operating systems, providing flexibility in your IT infrastructure.
Microsoft SQL Server has been a leader in database technology for years. The latest edition, Microsoft SQL Server 2019 Standard Edition, continues the legacy of robust database management.
New to SQL Licensing? Check out our SQL Server licensing guide to learn the features that would benefit you and how to license. For those looking to access the latest version, a SQL Server Standard Edition download is available. Take a deeper dive into SQL licensing with a licensing expert from our team in our Video Meetup below.
