What are the latest/key features in SQL Server 2019 ?

Like all the previous versions, the Microsoft SQL Server 2019 latest version is also jam-packed with new features and capabilities.

• Accelerated Database Recovery (ADR) - the SQL team has redeveloped how recovery works and has dramatically decreased how long this process takes.
• AlwaysEncrypted - SQL Server can now securely encrypt a portion of memory to perform computations on these encrypted columns without ever exposing the unencrypted values to the rest of the processes (or administrators).
• Performance improvement changes - There’s a new index optimization for indexes that have a sequential key, temp table recompilation improvements, improved indirect checkpoint scalability and more.
• Support for replication - SQL Server on Linux supports replication from 2019 version and this is a major addition!
• Optimization in tempDB - the tempdb’s system tables can be moved into memory-optimized tables taking the pressure off the disks. This helps handle heavy workload with ease.