Big Data Clusters:
SQL Server 2019 introduces significant data clusters that allow you to deploy scalable clusters of SQL Server, Apache Spark, and Hadoop Distributed File System (HDFS). This enables you to analyse big data and provide insights across various data sources.
Intelligent Query Processing: This feature enhances query performance by introducing various improvements, such as batch mode on row store, table variable deferred compilation, and approximate query processing.
Accelerated Database Recovery: Accelerated Database Recovery helps to reduce the time it takes to recover a database after a restart or a crash. It achieves this by avoiding undoing a long transaction's changes during recovery.
Enhanced PolyBase: PolyBase allows you to query and analyse data from external sources like Hadoop or Azure Blob Storage. ETC