Microsoft
Microsoft SQL Server 2019 Standard - License + 5 CALs
Microsoft SQL Server 2019 Standard - License + 5 CALs
Couldn't load pickup availability
Query and analyze your data using industry-leading performance and security on a variety of operating systems, like Windows, Linux, or Azure. Deploy SQL Server 2019 on a server + CAL or per-core model to support a broader collection of use cases.
Secure Your Data With SQL Server 2019
Relational and Big Data Come Together in SQL Server 2019 Standard Edition + 5 CALs.
How to License Microsoft SQL Server 2019 Standard Edition
Option #1
SERVER + CAL:
Server + CAL provides the option to license users and/or devices with low-cost access to incremental SQL Server deployments:
- Each instance running SQL Server software requires a license.
- Each user and/or device accessing a licensed SQL Server requires a SQL Server CAL that is the same version or newer (e.g., to access a SQL Server 2016 Standard Edition server, users need a SQL Server 2016, SQL Server 2017, or SQL Server 2019 CAL).
- Each SQL Server CAL allows users access to utilize SQL in their SQL environment, including Standard Edition, legacy Business Intelligence, and Enterprise Edition Servers, whether on-premises or in Azure.
Option #2
Pre-Core gives more precise measurements of computing power and a consistent metric, regardless of whether you deploy solutions on physical servers, in on-premises data centers, or in virtual or cloud environments.
- Core-based licensing is appropriate for scenarios including internet/extranet workloads, high availability configurations, and when customers cannot count users or devices accessing SQL.
- When running SQL Server in a physical OSE, you must license all physical cores on the server.
Download the full Microsoft SQL Server 2019 Licensing guide
Key Features of Microsoft SQL Server 2019
- Enhanced scalability and performance for data warehouses
- Advanced business intelligence capabilities
- Improved disaster recovery options
- Integrated machine learning with Python support
- Big data clusters for handling large-scale data
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 | ||||
Microsoft SQL Server has a strong history as an industry leader in relational database technology. SQL Server 2019 Standard Edition builds on this legacy, offering enhanced compatibility, virtualization support, and robust security features to protect against vulnerabilities, picking up right where its predecessors left off.
New to SQL Licensing? Understanding SQL Server standard pricing can be vital. Check out our SQL Server licensing guide to find out the features that would benefit you and how to license. Take a deeper dive into SQL licensing with a licensing expert from our team in our Video Meetup.
System Requirements
Check the software and hardware requirements directly from Microsoft’s learn page to verify that your system can support Microsoft SQL Server 2019 Standard Edition.
- Windows Server 2016 or later, Linux distributions
- Supports various enterprise workloads
- Available for both on-premises installations and Azure SQL deployments
