What is the difference between SQL 2016 and 2019?

Should I upgrade to SQL Server 2019?

You should consider SQL Server 2019 if… You want as much support lifespan as possible – because it's supported until 2030.

What is the difference between SQL 2016 and SQL 2017?

SQL Server 2017 will be fully supported for about 15 months longer than SQL Server 2016. Microsoft has a page with many resources about the end of support for SQL Server 2008 and 2008 R2. The Mainstream and Extended Support end dates for all recent versions of SQL Server are shown in Table 1.

What's New in Microsoft SQL Server 2019?

SQL Server 2019 (15. x) introduces Big Data Clusters for SQL Server. It also provides additional capability and improvements for the SQL Server database engine, SQL Server Analysis Services, SQL Server Machine Learning Services, SQL Server on Linux, and SQL Server Master Data Services.

What is the difference between SQL versions?

The most well known differences between SQL Express and other editions are the caps on database size (10GB) and lack of a SQL Agent feature. There are many other differences though, some of which can be extremely important for some application and architecture requirements.