Home Archives Authors Categories Newsletters Latest Builds About   GO
Download the SentryOne Plan Explorer Extension for Azure Data Studio
SentryOne Newsletters

The SQLPerformance.com bi-weekly newsletter keeps you up to speed on the most recent blog posts and forum discussions in the SQL Server community.

eNews is a bi-monthly newsletter with fun information about SentryOne, tips to help improve your productivity, and much more.


Featured Author

Jonathan Kehayias is a Principal Consultant with SQLskills and the youngest MCM ever.

Jonathan’s Posts

Latest Builds of SQL Server 2019

Last updated: May 13th, 2020

SQL Server 2019 became generally available on November 4th, 2019. Along with it came an important servicing update (GDR1 – 4517790) which should absolutely be installed in every environment. I really wish they could have just made that part of setup, but timing didn't work out; I hope I don't come across any RTM bits at any point in the future. If anything you should be on the latest cumulative update.

In some build lists you may have seen release and build dates published, but something that always felt missing was the internal database version, which can be important because it is impossible to restore a database from a higher db version to a lower one. Database version is indicated below in the DB Version column – helping to makes it clear that you can't take a backup from CTP 3.2 and restore it on CTP 3.0, for example. This internal database version is far less likely to change after GA, but it's possible; the internal database version of the latest builds of SQL Server 2017 is 869, but at GA it was 868. A different topic for a different time.

You can evaluate SQL Server 2019 here. The What's New page has summary information about all the changes, and the Release Notes contain more details and known issues. There are no deprecated engine features and no breaking changes, but there are three database scoped configuration options that have been discontinued. For feature-by-edition breakdowns, see the documentation and this blog post.

Label Build # Date KB Fixes (public) DB Version
Cumulative Update #5 Moved to June, per this announcement.
Cumulative Update #4 15.0.4033.1 2020-03-31 KB #4548597 50 (38) 904
Cumulative Update #3 15.0.4023.6 2020-03-12 KB #4538853 56 (11) 904
Cumulative Update #2 15.0.4013.40 2020-02-13 KB #4536075 134 (88) 904
Cumulative Update #1 15.0.4003.23 2020-01-07 KB #4527376 83 (62) 904
GDR1 15.0.2070.41 2019-11-04 KB #4517790 1 904
RTM / GA 15.0.2000.5 2019-11-04     904
Label Build # Date DB Version
RC1.1 Refresh 15.0.1900.47 2019-08-29 904
RC1 15.0.1900.25 2019-08-01 904
CTP 3.2 15.0.1800.32 2019-07-24 904
CTP 3.1 15.0.1700.37 2019-06-26 902
CTP 3.0 15.0.1600.8 2019-05-17 902
CTP 2.5 15.0.1500.28 2019-04-15 897
CTP 2.4 15.0.1400.75 2019-03-16 897
CTP 2.3 15.0.1300.359 2019-02-15 897
CTP 2.2 15.0.1200.24 2018-12-05 896
CTP 2.1 15.0.1100.94 2018-11-01 896
CTP 2.0 15.0.1000.34 2018-09-18 895