Harris Technology - SQL Server 2019

If you can't find the information you need, please use the Make an Enquiry page or phone 1300 13 9999 and get help from a Customer Service representative.

SQL Server 2019 provides industry leading security, performance and intelligence over all your data, structured and unstructured.




Get rich programming capabilities, security innovations and fast performance with Big Data Clusters for mid-tier applications and data marts. Easily upgrade to the Enterprise edition without changing any code.


Access mission-critical capabilities to achieve unparalleled scale, security, high availability and leading performance for your Tier 1 database, business intelligence and advanced analytics workloads.



Feature highlights

• Up to 24 cores of CPU

• Up to 128 GBs of memory

• SQL Server 2019 Big Data Clusters

• Data virtualization through PolyBase

• Enhanced in-memory performance

• Automatic intelligent database tuning

• Azure Data Studio with notebook support

Feature highlights

• Unlimited cores of CPU

• Unlimited memory

• Industry-leading performance with unmatched scalability

• Unlimited virtualization benefits

• Petabyte scale data warehousing

• Business critical HA on Windows and Linux

• Low TCO with free DR replicas

• Access to Power BI Report Server





Build, test and demonstrate applications using all the features of the Enterprise edition in your non-production dev/test environments.



SQL Server 2019 new 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 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 Compatibility certification  X  X
UTF-8 support  X  X
Support for SQL Server Java extension  X  X
Industryleading performance and availability 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








2016 Additions

2017 Additions

2019 Additions

• Real-time operational analytics

• PolyBase

• R language support

• SQL Server Machine Learning Services

• Dynamic data masking, Row level security and Always encrypted

• End to end mobile BI

• Support for Linux including Red Hat

Enterprise Linux (RHEL), SUSE Linux

Enterprise Server (SLES), and Ubuntu

• Support for Docker containers on Linux and Windows

• Python language support

• Support for graph data

• Automatic plan correction and adaptive query processing

• Cross platform availability groups

• Power BI reporting both on-premises and in the cloud

• Access to Power BI Report Server

• Big Data clusters with Apache Spark and HDFS

• Data virtualization to integrate external data sources

• Azure Machine Learning and Spark ML

• Support for Kubernetes deployment

• Free supported Java

• Native UTF-8 support

• Intelligent Query processing

• In-Memory Database: Persistent Memory support

• Accelerated database recovery

• Free DR to Azure

• Always Encrypted with secure enclaves

• Data classification & auditing

• Vulnerability assessment

• Notebook support for T-SQL, Python, R, and Scala in Azure Data Studio

• SQL Server Analysis Services Direct Query