SQL Server 2019 articles, fixes and updates - Year 2023

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2019 that have been released in Year 2023. The list is daily updated.

• 5029377 Description of the security update for SQL Server 2019 GDR: October 10, 2023 Q5029377 KB5029377 October 10, 2023
• 5027702 Cumulative Update 22 for SQL Server 2019 Q5027702 KB5027702 August 14, 2023
• 5016729 Improvement: Enable distributed availability groups on SQL Server Standard editions with Azure services Q5016729 KB5016729 August 7, 2023
• 5023049 Cumulative Update 19 for SQL Server 2019 Q5023049 KB5023049 June 29, 2023
• 5017593 Cumulative Update 18 for SQL Server 2019 Q5017593 KB5017593 June 29, 2023
• 5016394 Cumulative Update 17 for SQL Server 2019 Q5016394 KB5016394 June 29, 2023
• 5011644 Cumulative Update 16 for SQL Server 2019 Q5011644 KB5011644 June 29, 2023
• 5008996 Cumulative Update 15 for SQL Server 2019 Q5008996 KB5008996 June 29, 2023
• 5005679 Cumulative Update 13 for SQL Server 2019 Q5005679 KB5005679 June 29, 2023
• 5004524 Cumulative Update 12 for SQL Server 2019 Q5004524 KB5004524 June 29, 2023
• 5003249 Cumulative Update 11 for SQL Server 2019 Q5003249 KB5003249 June 29, 2023
• 5001090 Cumulative Update 10 for SQL Server 2019 Q5001090 KB5001090 June 29, 2023
• 5000642 Cumulative Update 9 for SQL Server 2019 Q5000642 KB5000642 June 29, 2023
• 4570012 Cumulative Update 7 for SQL Server 2019 Q4570012 KB4570012 June 29, 2023
• 4563110 Cumulative Update 6 for SQL Server 2019 Q4563110 KB4563110 June 29, 2023
• 4552255 Cumulative Update 5 for SQL Server 2019 Q4552255 KB4552255 June 29, 2023
• 4548597 Cumulative Update 4 for SQL Server 2019 Q4548597 KB4548597 June 29, 2023
• 4537749 Improvement: Port additional two system tables in Tempdb Memory-Optimized Metadata feature in SQL Server 2019 Q4537749 KB4537749 June 29, 2023
• 4536075 Cumulative Update 2 for SQL Server 2019 Q4536075 KB4536075 June 29, 2023
• 4527376 Cumulative Update 1 for SQL Server 2019 Q4527376 KB4527376 June 29, 2023
• 5000895 Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index Q5000895 KB5000895 June 20, 2023
• 5000715 FIX: Failures with log reader agent occur when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 Q5000715 KB5000715 June 20, 2023
• 4563348 After upgrading SQL Server 2017 Distributor to SQL Server 2019, transactional push replication fails when subscriber is using non-default port Q4563348 KB4563348 June 20, 2023
• 5024276 Cumulative Update 20 for SQL Server 2019 Q5024276 KB5024276 June 16, 2023
• 5025808 Cumulative Update 21 for SQL Server 2019 Q5025808 KB5025808 June 15, 2023
• 4518398 SQL Server 2019 build versions Q4518398 KB4518398 June 15, 2023
• 4580949 FIX: Snapshot agent fails when you create Transactional Publication with all tables and UDFs in SQL Server 2019 Q4580949 KB4580949 June 9, 2023
• 4580915 FIX: SQL Server error log receives several ADR enabled/disabled messages even when ADR isn't explicitly enabled/disabled Q4580915 KB4580915 June 9, 2023
• 4580648 FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS Q4580648 KB4580648 June 8, 2023
• 4580639 FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 Q4580639 KB4580639 June 8, 2023
• 4580413 FIX: Deadlock occurs between Availability Group Configuration and Replica Transport State Lock in SQL Server 2019 Q4580413 KB4580413 June 8, 2023
• 4579223 FIX: PolyBase processes delayed to avoid data dump during provisioning in SQL Server 2019 Q4579223 KB4579223 June 8, 2023
• 5017009 FIX: sp_replmonitorsubscriptionpendingcmds returns incorrect pending commands for P2P replication Q5017009 KB5017009 May 12, 2023
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 April 26, 2023
• 5007182 Cumulative Update 14 for SQL Server 2019 Q5007182 KB5007182 April 17, 2023
• 4577194 Cumulative Update 8 for SQL Server 2019 Q4577194 KB4577194 April 17, 2023
• 4538853 Cumulative Update 3 for SQL Server 2019 Q4538853 KB4538853 April 17, 2023
• 4517790 Servicing Update for SQL Server 2019 RTM Q4517790 KB4517790 April 17, 2023
• 957826 Where to find information about the latest SQL Server builds Q957826 KB957826 February 23, 2023
• 5014353 Description of the security update for SQL Server 2019 CU16: June 14, 2022 Q5014353 KB5014353 February 22, 2023
• 5021125 Description of the security update for SQL Server 2019 GDR: February 14, 2023 Q5021125 KB5021125 February 21, 2023
• 5021124 Description of the security update for SQL Server 2019 CU18: February 14, 2023 Q5021124 KB5021124 February 21, 2023
• 5022920 FIX: Table-valued function that uses a parameter and the OPTION (OPTIMIZE FOR) clause gives incorrect results on the first run Q5022920 KB5022920 February 16, 2023
• 5018231 FIX: Error 20598 after adding columns that have default constraints as part of the primary key for an existing table and configuring transactional replication Q5018231 KB5018231 February 16, 2023
• 5017788 FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml Q5017788 KB5017788 February 16, 2023
• 4521739 FIX: Error occurs when CDC capture process tries to insert duplicate key in table "cdc.lsn_time_mapping" in SQL Server 2016, 2017 and 2019 Q4521739 KB4521739 January 11, 2023
• 4530287 Improvement: Dynamic Management View is added for external authentication in SQL Server 2019 Q4530287 KB4530287 January 5, 2023