SQL Server 2019 articles, fixes and updates - Year 2021

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 2021. The list is daily updated.

• 4552478 FIX: Distribution Agent "Parameterized values for above command" log message is missing Q4552478 KB4552478 November 24, 2021
• 5008114 FIX: The built-in SESSION_CONTEXT returns wrong results in parallel plans Q5008114 KB5008114 November 22, 2021
• 5008107 Improvement: Cardinality estimation in Spatial TVF functions in SQL Server 2019 Q5008107 KB5008107 November 22, 2021
• 5007842 FIX: An assertion occurs when Compute Scalar operator operates on computed, temporary lobs with batch mode Q5007842 KB5007842 November 22, 2021
• 5007794 FIX: Non-yielding scheduler dumps during the recovery of a secondary availability database with a database snapshot Q5007794 KB5007794 November 22, 2021
• 5007744 FIX: Add checkpoint handling for the first row in NonOptimizedGetAndInsertRows Q5007744 KB5007744 November 22, 2021
• 5007719 FIX: Creating a resumable clustered index on a table with LOB causes corruption in SQL Server 2019 Q5007719 KB5007719 November 22, 2021
• 5004936 FIX: Error when you use columnstore indexes and run versioned scans if all rows in a compressed rowgroup are deleted in SQL Server 2017 and 2019 Q5004936 KB5004936 November 22, 2021
• 5006632 FIX: An assertion dump occurs many times in SQL Server 2019 Q5006632 KB5006632 October 18, 2021
• 5005832 FIX: Cannot fetch a row by using OPENROWSET or OPENDATASOURCE and "MSOLEDBSQL" OLE DB driver for SQL Server in batch mode Q5005832 KB5005832 October 14, 2021
• 5006665 Improvement: Last Writer Wins and support for P2P database in Availability Group Q5006665 KB5006665 October 12, 2021
• 5006359 FIX: A dump occurs if you use the same synonym for a user-defined function in the view definition Q5006359 KB5006359 October 5, 2021
• 5005788 FIX: Access violation occurs when you use FileTable feature with Windows Defender enabled Q5005788 KB5005788 October 5, 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
• 5003596 FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 Q5003596 KB5003596 September 16, 2021
• 4578579 Improvement: Availability Group listener without the load balancer in SQL Server 2016, 2017 and 2019 Q4578579 KB4578579 September 16, 2021
• 4541303 FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server Q4541303 KB4541303 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
• 4515772 FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server Q4515772 KB4515772 September 15, 2021
• 5004750 FIX: SQL Server often crashes when network.forceencryption property is set to '1' Q5004750 KB5004750 September 14, 2021
• 5004734 FIX: Persisted computed columns not being consistently blocked for Columnstore index Q5004734 KB5004734 September 14, 2021
• 5004573 FIX: SQL Server affinity settings are reset after applying CU for SQL Server 2017 and 2019 Q5004573 KB5004573 September 14, 2021
• 4561725 Improvement: Enables PolyBase Xevent Session in SQL Server 2019 Q4561725 KB4561725 August 31, 2021
• 5005321 FIX: Dropping an index from the view on primary may cause access violation on readable secondary Q5005321 KB5005321 August 4, 2021
• 5004733 FIX: Debug assert when a lock is acquired by the ParNested Transaction and attempts to get logged in sLog for the parent transaction Q5004733 KB5004733 August 4, 2021
• 5004649 FIX: Parallel redo failure on secondary replica in SQL Server 2019 Q5004649 KB5004649 August 4, 2021
• 5004560 FIX: Wrong results during Clustered Columnstore Index alter "index reorganize" in versioned scans in SQL Server 2017 and 2019 Q5004560 KB5004560 August 4, 2021
• 5001045 FIX: Memory grant wait times out when you run many Columnstore bulk inserts concurrently in SQL Server 2017 and 2019 Q5001045 KB5001045 August 4, 2021
• 4539340 FIX: Issue occurs when using PolyBase for SQL Server 2019 generic ODBC with drivers from Microsoft Access Database Engine Redistributable package Q4539340 KB4539340 June 11, 2021
• 5003870 FIX: Support using the PolyBase SQL Server connector to create external table with remote database name containing a period Q5003870 KB5003870 June 10, 2021
• 5003869 FIX: Support schema reflection stored procedures for the Polybase generic ODBC connector Q5003869 KB5003869 June 10, 2021
• 5003750 FIX: Performance issues occur when metadata is scanned to find keys to be sent to the AE enclave in SQL Server 2019 Q5003750 KB5003750 June 10, 2021
• 5003589 FIX: Error 19432 occurs when Log Writer thread fails to send a log back and stop log capture on Log Writer threads in SQL Server 2019 Q5003589 KB5003589 June 10, 2021
• 5003525 Improvement: ADLS Gen2 support for External Tables Q5003525 KB5003525 June 10, 2021
• 5003342 FIX: SQL Server Express LocalDB can't start or connect to shared instances of SQL Server Express LocalDB 2019 or 2017 Q5003342 KB5003342 June 10, 2021
• 4581886 FIX: Joins not getting pushed down for PolyBase query that joins multiple external tables Q4581886 KB4581886 June 10, 2021
• 4023170 FIX: Error 574 when you try to install Service Pack 2 for SQL Server 2014 Q4023170 KB4023170 June 10, 2021
• 5001260 Improvement: Performance improvements of several spatial built-in properties and methods in SQL Server Q5001260 KB5001260 May 11, 2021
• 5000715 FIX: Failures with log reader agent occurs when you create and drop publication on CDC-enabled database in SQL Server 2019, 2017 or 2016 Q5000715 KB5000715 May 11, 2021
• 4589350 FIX: MERGE statement fails with Access Violation at BTreeRow::DisableAccessReleaseOnWait in SQL Server Q4589350 KB4589350 May 11, 2021
• 4583468 Microsoft SQL Server elevation of privilege vulnerability Q4583468 KB4583468 April 16, 2021
• 5000649 FIX: Wrong results due to undetected concatenation parameters from scalar expression Q5000649 KB5000649 April 7, 2021
• 5001526 FIX: Access violation occurs when Dynamic Data Masking and nested UDFs are used in SQL Server 2019 Q5001526 KB5001526 April 6, 2021
• 5001517 FIX: Metadata deadlock causes availability issues when changing auditing properties in SQL Server 2019 Q5001517 KB5001517 April 6, 2021
• 5001266 FIX: Access violation occurs when hybrid buffer pool is enabled in SQL Server 2019 Q5001266 KB5001266 April 6, 2021
• 5001159 FIX: Assertion failure occurs when Online Clustered Columnstore Index Rebuild reuses truncated hobt instead of new hobt in SQL Server 2019 Q5001159 KB5001159 April 6, 2021
• 5001044 FIX: Wrong results occur when you run a query on In-Memory optimized tables in SQL Server Q5001044 KB5001044 April 6, 2021
• 5000650 FIX: Incorrect results occur when you run query on In-memory optimized table that has clustered columnstore index in SQL Server 2016 or 2019 Q5000650 KB5000650 April 6, 2021
• 4548523 FIX: Database creation to Azure blob storage from SQL Server 2017 or 2019 on Linux may fail with error Q4548523 KB4548523 April 6, 2021
• 4486936 FIX: "Login failed for user" error occurs when you run Maintenance plan with SQL login account in SQL Server Q4486936 KB4486936 April 6, 2021
• 5000670 FIX: Error occurs when you map an Oracle NUMBER type to a T-SQL DECIMAL/NUMERIC type Q5000670 KB5000670 March 18, 2021
• 5000656 FIX: Incorrect type of data mask is applied when DDM is used with queries that have UDFs in SQL Server 2019 Q5000656 KB5000656 March 18, 2021
• 5000655 FIX: Memory leak may occur when SQL Server auditing feature is used on an instance of SQL Server 2019 Q5000655 KB5000655 March 18, 2021
• 4585971 FIX: User session is in rollback state indefinitely after it is killed in SQL Server Q4585971 KB4585971 March 18, 2021
• 4568447 FIX: Automatic seeding failure occurs for a secondary replica in SQL Server Q4568447 KB4568447 February 27, 2021
• 4582558 FIX: SQL Server service fails to start in Linux operating system Q4582558 KB4582558 February 25, 2021
• 4575940 FIX: Newly added articles' snapshot doesn't get applied to subscriber in SQL Server Q4575940 KB4575940 February 25, 2021
• 3135244 TLS 1.2 support for Microsoft SQL Server Q3135244 KB3135244 February 25, 2021
• 4589170 FIX: Indefinite hang during cube processing after applying SSAS 2016 SP2 CU7 Q4589170 KB4589170 February 24, 2021
• 4588977 FIX: SQL Server crashes when Afd!DbCreateSocketOperation process fails Q4588977 KB4588977 February 24, 2021
• 4580397 FIX: Incorrect results when you run INSERT INTO SELECT statement on memory-optimized table variables in SQL Server Q4580397 KB4580397 February 24, 2021
• 4575939 FIX: Log reader agent generates access violation exception for P2P or transactional replication with partitioning tables in SQL Server Q4575939 KB4575939 February 24, 2021
• 4571296 Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command Q4571296 KB4571296 February 24, 2021
• 4569837 FIX: Intermittent connection error occurs when an expression is used for both connection string and password of a connection manager Q4569837 KB4569837 February 24, 2021
• 4547890 FIX: ISDBUpgradeWizard.exe throws error when you try to upgrade SSISDB after restoring from earlier versions in SQL Server Q4547890 KB4547890 February 24, 2021
• 4589171 FIX: Unexpected error occurs when a query is run on an instance of SSAS Q4589171 KB4589171 February 15, 2021
• 4575689 FIX: Incorrect results can occur when you run linked server query with aggregates or joins on table with filtered index on a remote server in SQL Server Q4575689 KB4575689 February 15, 2021
• 5000895 Improvement: New trace Flags for better maintenance of deleted rows in Clustered Columnstore Index Q5000895 KB5000895 February 12, 2021
• 4589345 FIX: Error 3625 occurs during query execution when batch mode on rowstore is enabled in SQL Server 2019 Q4589345 KB4589345 February 12, 2021
• 4588984 FIX: Contention on XVB_List spinlock in highly concurrent workloads when using RCSI Q4588984 KB4588984 February 12, 2021
• 5000672 FIX: Fixes reading of NULL Time fields for non-sqlserver backends Q5000672 KB5000672 February 11, 2021
• 5000671 FIX: Error occurs when casting non-Unicode string column using a Unicode-only UTF8 collation in SQL Server 2019 Q5000671 KB5000671 February 11, 2021
• 5000669 Improvement: Adds a new external generic query builder in SQL Server 2019 Q5000669 KB5000669 February 11, 2021
• 5000663 FIX: Database mail doesn't send email messages when IP address is specified in mssql-conf Q5000663 KB5000663 February 11, 2021
• 4594016 FIX: Assertion failure error occurs on sqlmin.dll!XdesRMBase::StartStmtSnapshot in SQL Server 2019 Q4594016 KB4594016 February 11, 2021
• 4588983 FIX: CREATE STATISTICS WITH SAMPLE PERCENT command fails with error when Oracle data source has partitioned table Q4588983 KB4588983 February 11, 2021
• 4588982 FIX: sys.dm_exec_requests returns transaction_id as "0" in certain scenarios in SQL Server 2019 Q4588982 KB4588982 February 11, 2021
• 4588981 FIX: "LogConsumer::StartScan failed to get the control lock" error occurs and the log writer activity stops completely in SQL Server 2019 Q4588981 KB4588981 February 11, 2021
• 4588980 FIX: Higher than expected number of single row Columnstore rowgroups may be generated for Columnstore bulk insert when both large page allocator and scalable Columnstore bulk insert features are turned on Q4588980 KB4588980 February 11, 2021
• 4588979 FIX: Fail to create AG on top of FCI in SQL Server 2019 Q4588979 KB4588979 February 11, 2021
• 4588978 FIX: Statistics are ignored when a query is run on PolyBase external table in SQL Server 2019 Q4588978 KB4588978 February 11, 2021
• 4577976 FIX: COMPILE blocking occurs when executing many concurrent stored procedures in SQL Server 2017 and 2019 Q4577976 KB4577976 February 11, 2021
• 4577933 FIX: Cascade delete on key values outside of leading table histogram bounds causes index scan in SQL Server 2017 and 2019 Q4577933 KB4577933 February 11, 2021
• 4577932 FIX: Access Violation exception occurs in Availability Groups in SQL Server 2017 under certain conditions Q4577932 KB4577932 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
• 4034376 FIX: Couldn't disable "change data capture" if any column is encrypted by "Always Encrypted" feature in SQL Server Q4034376 KB4034376 January 26, 2021
• 4534430 Msg 33111 error after SQL Server TDE certificate or key rotation Q4534430 KB4534430 January 25, 2021
• 4583459 Description of the security update for SQL Server 2019 CU8: January 12, 2021 Q4583459 KB4583459 January 16, 2021
• 4583458 Description of the security update for SQL Server 2019 GDR: January 12, 2021 Q4583458 KB4583458 January 16, 2021
• 4580648 FIX: Errors may occur or PolyBase services fail to start when you run PolyBase queries on a non-English OS Q4580648 KB4580648 January 14, 2021
• 4580639 FIX: PolyBase queries can now be run with EXECUTE AS impersonation context in SQL Server 2019 Q4580639 KB4580639 January 14, 2021
• 4579223 FIX: PolyBase processes delayed to avoid data dump during provisioning in SQL Server 2019 Q4579223 KB4579223 January 14, 2021
• 4578292 FIX: Error occurs when you try to deploy CU5 or CU6 for SQL Server 2019 BDC irrespective of the azdata version Q4578292 KB4578292 January 14, 2021
• 4577837 FIX: Queries fail if storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster Q4577837 KB4577837 January 14, 2021
• 4577594 FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 Q4577594 KB4577594 January 14, 2021
• 4563007 FIX: VDI backup fails with error after applying SQL Server 2019 CU2/CU3/CU4 or SQL Server 2017 CU19/CU20/CU21 Q4563007 KB4563007 January 14, 2021
• 4538496 FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 Q4538496 KB4538496 January 14, 2021
• 4538017 FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 Q4538017 KB4538017 January 14, 2021
• 4594205 "Attempted to perform an unauthorized operation" error when you set up or update SQL Server instances Q4594205 KB4594205 January 13, 2021