SQL Server 2019 builds on intelligent query processing features that were implemented in SQL Server 2017, and expands them to new areas of the database engine.

Microsoft's database releases from 2008 and 2010 reach end of extended support. In response, Redmond says, that for many customers, the time for cloud migration has arrived.

In SQL Server 2019, support for these devices is extended, namely for Intel Optane DC NV-DIMMs, on Windows Server 2019. This allows all database objects to be stored on persistent memory as normal ...