SQL Server 2019 articles, fixes and updates - letter I

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

• 5018050 Improvement: Add new Azure SQL Database service tier options to the Stretch Database feature Q5018050 KB5018050 June 19, 2024
• 5016729 Improvement: Enable distributed availability groups on SQL Server Standard editions with Azure services Q5016729 KB5016729 August 7, 2023
• 4537749 Improvement: Port additional two system tables in Tempdb Memory-Optimized Metadata feature in SQL Server 2019 Q4537749 KB4537749 June 29, 2023
• 5000895 Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index Q5000895 KB5000895 June 20, 2023
• 4530287 Improvement: Dynamic Management View is added for external authentication in SQL Server 2019 Q4530287 KB4530287 January 5, 2023
• 5016780 Improvement: Provide the closest matching non-UTF8 collation for the client drivers that don't support UTF-8 Q5016780 KB5016780 August 11, 2022
• 5014047 Improvement: Match the lock escalation policy for the change tracking table to that of the base table Q5014047 KB5014047 July 13, 2022
• 4538205 Improvement: Download new CAB files that have fixes for R/Python runtime features Q4538205 KB4538205 June 2, 2022
• 5014137 Improvement: Make the EO-compliant Microsoft Extensibility SDK available for Java for SQL Server 2019 Q5014137 KB5014137 May 17, 2022
• 5014136 Improvement: Make the EO-compliant ML service CAB packages available for SQL Server 2019 Q5014136 KB5014136 May 17, 2022
• 5012964 Improvement: Add an XEvent for tracking manual user plan forcing and unforcing Q5012964 KB5012964 May 17, 2022
• 5010555 Improvement: Add the usage of signed certificates with multiple DNS names Q5010555 KB5010555 January 27, 2022
• 5010246 Improvement: Add 1 (true) and 0 (false) as valid values to mssql-conf Boolean settings Q5010246 KB5010246 January 27, 2022
• 5008648 Improvement: Add a setting for the machine key location on Linux Q5008648 KB5008648 January 27, 2022
• 5008647 Improvement: Add mssql-conf and adutil utilities to SQL Server 2019 Q5008647 KB5008647 January 27, 2022
• 5008107 Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 Q5008107 KB5008107 November 22, 2021
• 5006665 Improvement: Last Writer Wins and support for P2P database in Availability Group Q5006665 KB5006665 October 12, 2021
• 4530907 Improvement: Corrupted statistics can be detected by using extended_logical_checks in SQL Server 2016, 2017, and 2019 Q4530907 KB4530907 October 5, 2021
• 5003937 Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 and 2016 Q5003937 KB5003937 September 16, 2021
• 4578579 Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 Q4578579 KB4578579 September 16, 2021
• 4541132 Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2016, 2017 and 2019 Q4541132 KB4541132 September 16, 2021
• 4537868 Improvement: Enable DNN feature in SQL Server 2016 and 2019 FCI Q4537868 KB4537868 September 15, 2021
• 4561725 Improvement: Enables PolyBase Xevent Session in SQL Server 2019 Q4561725 KB4561725 August 31, 2021
• 5003525 Improvement: ADLS Gen2 support for External Tables Q5003525 KB5003525 June 10, 2021
• 5001260 Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server Q5001260 KB5001260 May 11, 2021
• 4571296 Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command Q4571296 KB4571296 February 24, 2021
• 5000669 Improvement: Adds a new external generic query builder in SQL Server 2019 Q5000669 KB5000669 February 11, 2021
• 4565944 Improvement: A manual method to set maximum group commit time in SQL Server 2017 and 2019 Q4565944 KB4565944 February 11, 2021
• 4561915 Improvement: MAXTRANSFERSIZE no longer required to enable backup compression on TDE encrypted databases Q4561915 KB4561915 January 20, 2021
• 4538978 Improvement: Add BDC storage pool cache in SQL Server 2019 Q4538978 KB4538978 January 20, 2021
• 4538759 Improvement: Module and offset information is sent as output for dumps in SQL Server 2019 Q4538759 KB4538759 January 20, 2021
• 4538689 Improvement: Add BDC data/storage pool nodes DMVs in SQL Server 2019 Q4538689 KB4538689 January 20, 2021
• 4538686 Improvement: Add new Protection Key feature work for SQL Server 2019 on Linux Q4538686 KB4538686 January 20, 2021
• 4538595 Improvement: New features included in library management for external languages in SQL Server 2019 Q4538595 KB4538595 January 20, 2021
• 4538382 Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux Q4538382 KB4538382 January 20, 2021
• 4538118 Improvement: Enable hybrid buffer pool read caching in SQL Server 2019 Q4538118 KB4538118 January 20, 2021
• 4538112 Improvement: Use QUOTENAME with EXECUTE AT to query on table that has column name with quotes in SQL Server 2019 Q4538112 KB4538112 January 20, 2021
• 4531125 Improvement: Update the hktempdb.dll version in SQL Server 2019 Q4531125 KB4531125 January 20, 2021
• 4531025 Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019 Q4531025 KB4531025 January 20, 2021
• 4530814 Improvement: Add support to create index on encrypted unique identifier using Always Encrypted with secure enclaves feature in SQL Server 2019 Q4530814 KB4530814 January 20, 2021
• 4530302 Improvement: Add unlimited buffer size to support TDS V1 and V2 in SQL Server 2019 Q4530302 KB4530302 January 20, 2021
• 4530286 Improvement: Update SDK to improve security of Always Encrypted by using secure enclaves in SQL Server 2019 Q4530286 KB4530286 January 20, 2021
• 4530283 Improvement: Execute Database upgrade scripts when Database state changes in SQL Server 2019 Q4530283 KB4530283 January 20, 2021
• 4530280 Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019 Q4530280 KB4530280 January 20, 2021
• 4530080 Improvement: Update the misspelled words in server_principal_sid and server_principal_name description in SQL Server 2019 Q4530080 KB4530080 January 20, 2021
• 4530079 Improvement: Update error messages of Always Encrypted with secure enclaves in SQL Server 2019 Q4530079 KB4530079 January 20, 2021
• 4538493 Improvement: Restore database and add database to the AG in SQL Server 2019 Q4538493 KB4538493 February 15, 2020
• 4538160 Improvement: Correct the floating point data type in SQL Server 2019 Q4538160 KB4538160 February 14, 2020
• 3210239 Interoperability of Columnstore indexes with large page memory model in SQL Server Q3210239 KB3210239 December 16, 2019