Microsoft SQL Server Standard 2019 *License only*

Availability:

1-4 weeks


SQL Server 2019 offers customers a variety of licensing
options aligned with how customers typically purchase
specific workloads. There are two main licensing models
that apply to SQL Server:

• Cross edition rights are currently available for certain SQL Server products only and allow customers to
deploy an alternate (usually lower) edition in place of the currently licensed edition. SQL Server cross
edition rights can be combined with the version downgrade rights (available for all products offered under
a Volume Licensing Agreement) that allow customers to deploy prior versions of the software in place of
the currently licensed version. In some cases, rights to deploy prior versions of product editions other than
the edition currently licensed may also be allowed.

PER CORE: Gives customers a more precise measure of
computing power and a more consistent licensing metric,
regardless of whether solutions are deployed on physical
servers on-premises, or in virtual or cloud environments.
• Core based licensing is appropriate when customers are
unable to count users/devices, have Internet/Extranet
workloads or systems that integrate with external facing
workloads.
• To license a physical server—when running SQL Server in
a physical OSE—all physical cores on the server must be
licensed.
• A minimum of four core licenses are required for each
physical processor on the server.
SERVER + CAL: Provides the option to license users and/or
devices, with low cost access to incremental SQL Server
deployments.
• Each server running SQL Server software requires a server
license.
• Each user and/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 2012
Standard Edition server, a user would need a SQL Server
2012 or 2019 CAL.
• Each SQL Server CAL allows access to multiple licensed
SQL Servers, including Standard Edition and legacy
Business Intelligence and Enterprise Edition Servers.

Category:

SQL Server 2019 features.
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 certification
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 in lining, 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
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