Overview

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.

 

 

 

 

Trust nine years of proven security leadership

Make faster, better decisions

 

Achieve your security and compliance goals using the database rated as least vulnerable over the last nine years. Stay a step ahead using built-in features for data classification, data protection, and monitoring and alerts*.

 

* National Institute of Standards and Technology Comprehensive Vulnerability Database

Turn data into answers using the enterprise reporting capabilities of SQL Server Reporting Services along with the included Power BI Report Server, which gives your users access to rich, interactive Power BI reports on any device.

 

 

Features

SQL 2019 Feature Comparison

 

 

 

 

Category

Feature

Standard

Enterprise

Compute and storage

Maximum number of cores

24

OS Max

Maximum memory utilised per instance

128GB

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

x

x

Data virtualization using PolyBase (including additional data sources like Oracle, Teradata, MongoDB, and other SQL Server databases)

x

x

Unified AI platform to train and operationalize models with SQL Server ML Services

x

x

Choice of language and platform

Industry-leading performance and availability

Compatibility certification

x

x

UTF-8 support

x

x

Support for SQL Server Java extension

x

x

Free DR replicas in Azure and on-premises

x

x

Intelligent Query processing: Scalar UDF inlining, table variable deferred compilation, approximate count distinct

x

x

Intelligent Query processing features: row mode memory grant feedback, batch mode for row store and automatic tuning


x

Automatic read-write connection re-routing


x

In-Memory Database: memory-optimized tempdb


x

In-Memory Database: Persistent Memory support


x

x

Accelerated Database recovery

x

x

Secure and reliable

Always encrypted with secure enclaves

x

x

Transparent database encryption

x

x

Data classification and auditing

x

x

Vulnerability assessment


x

x

Quick business insights

Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks

x

x

SQL Server Analysis Services Direct Query

x

x

 





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.



  • 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 & CLIENT ACCESS LICENCE



Provides the option to license users and/or devices, with low cost access to incremental SQL Server deployments.

Please note that this option is not available through software subscriptions. 



  • 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.
  • Each user and/or device that is accessing the SQL server either directly or indirectly requires a SQL Server CAL



For further information on all scenarios for licensing for SQL server 2019, click here.