SQL Server 2019 brings enhancements in the core SQL engine, offers a scale-up and scale-out system with built in support for Big Data (Apache Spark, Data Lake), state of the art data virtualization technology, and with built-in machine learning capabilities.
Top 10 Additional Features:
Support to Persistent Memory (PMEM) Devices
SQL Server 2019 provides support to Persistent Memory (PMEM) devices. SQL Server directly accesses the device, bypassing the storage stack of the operating system for the files placed on the PMEM device.
Columnstore Index Enhancements
SQL Server 2019 also provides enhancements to columnstore index features such as columnstore index maintenance, better metadata memory management, a low-memory load path for columnstore tables, and improved performance for bulk loading to columnstore indexes.
Resumable Online Index Creation
SQL Server 2019 also provides support for resumable online index creation similar to resumable online index rebuilds in SQL Server 2017.
Up to Five Synchronous Replica Pairs for Availability Groups
We can now configure up to five synchronous replicas in an Availability Groups AG (one primary and up to four secondary replicas) with automatic failover between these replicas.
Enable High Availability Configurations for SQL Server Running in Containers
With SQL Server 2019, we can configure Always on Availability Groups using Kubernetes as an orchestration layer.
Better Scale-out with Automatic Redirection of Connections Based on read/write Intent
In SQL Server 2019, client applications can connect to any of the replicas of the Availability Group. The connection redirects to the primary replica as per the AG configuration and connection string.
SQL Data Discovery and Classification
We have explored this feature in SSMS 17.5. In SQL Server 2019, SQL Data discovery and classification is integrated into the SQL Server engine with new metadata. This enables us to ensure GDPR and other compliance needs for our databases.
Always Encrypted with Secure Enclaves
SQL Server 2019 introduces the secure enclave technology. A secure enclave extends client applications, data trust to the server side. It secures the data from the malware and privileged users.
Certificate Management Functionality in SQL Server Configuration Manager
In SQL Server 2019, certificate management is integrated into the SQL Server Configuration Manager. We can view, validate the certificates being used in SQL Server instance. We can view and validate certificates installed in a SQL Server instance. This also provides detail about certification expiration dates. This feature helps to manage certificates in a better way. We can also deploy certificates for AG instances starting from the primary replica.
SQL Server 2019 provides support for UTF-8 character encoding. We can now create a char or varchar column to store UTF-8 data. This feature improves data compatibility and performance improvements.
Try SQL Server 2019 on E2E Cloud – World Class Cloud from India.
Click on link for a free trial – https://bit.ly/E2ECloudSignup