Benefits of SQL Server 2019
On November 4, 2019, the latest version of SQL Server was released: SQL Server 2019. In this article, you can find links to SQL documentation for some of the most important enhancements in this newest release and what to expect when upgrading.
KEY BENEFITS OF THE LATEST RELEASE
A few of these key benefits include Big Data Clusters to facilitate the deployment of scalable clusters, new in-memory features, improved workload performance with intelligent query processing (IQP), an accelerated database recovery process, protection of sensitive data with the new Always Encrypted feature, collation and Unicode support for data and, finally, free Java support. See the documentation below to learn more about each feature.
- Introduction of Big Data Clusters
- https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-overview?view=sql-server-ver15
- In-Memory Database, Memory-Optimized tempdb
- https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-database?view=sql-server-ver15
- Intelligent Performance
- https://docs.microsoft.com/en-us/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15
- Accelerated Database Recovery
- https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-and-recovery-overview-sql-server?view=sql-server-ver15#adr
- Always Encrypted with Secure Enclaves
- https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver15