SQL Server 2019
Apply intelligence across all your data with SQL Server 2019
What you’ll love about SQL Server 2019
Analyse every type of data
Choose your platform and language
Rely on industry-leading performance
Gain insights from all your data by querying across relational, non-relational, structured, and unstructured data, for a complete picture of your business using SQL Server 2019 with Apache Spark built in.
Get the flexibility to use the language and platform of your choice with open source support. Run SQL Server on Linux containers with Kubernetes support or on Windows.
Take advantage of breakthrough scalability and performance to improve the stability and response time of your database—without making app changes. Get high availability for mission-critical applications, data warehouses, and data lakes.
SQL 2019 Licensing Guide
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:
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.
SERVER & CLIENT ACCESS LICENCE
Provides the option to license users and/or devices, with low cost access to incremental SQL Server deployments.
For further information on all scenarios for licensing for SQL server 2019, click here.
SQL 2019 Feature Comparison
Category
Feature
Standard
Enterprise
Compute and storage
Maximum number of cores
24
OS Max
Maximum memory utilised per instance
128GB
Maximum size
524 PB
Intelligence over all your data
SQL Server 2019 Big Data Clusters with Apache Spark and HDFS built into SQL Server engine
x
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
Industry-leading performance and availability
Compatibility certification
UTF-8 support
Support for SQL Server Java extension
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
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