SQL Server 2019 articles, fixes and updates - January 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 January 2021. The list is daily updated.

• 4534430 Msg 33111 error after SQL Server TDE certificate or key rotation Q4534430 KB4534430 January 25, 2021
• 4581882 FIX: Restoring database fails due to backup command time-out in SQL Server 2019 Q4581882 KB4581882 January 20, 2021
• 4578395 FIX: Error occurs when using DBCC operations while TDE key change occurs in SQL Server 2019 Q4578395 KB4578395 January 20, 2021
• 4578267 FIX: Different result set for the same query using dm_sql_referenced_entities in SQL Server 2019 Q4578267 KB4578267 January 20, 2021
• 4578110 FIX: Error 8992 occurs when you run DBCC CHECKDB on cloned database in SQL Server 2017 and 2019 Q4578110 KB4578110 January 20, 2021
• 4578011 FIX: Unable to restore SQL Server database from previous versions on NVMe device partitioned in 4K block size Q4578011 KB4578011 January 20, 2021
• 4577836 FIX: Inconsistency occurs when ghost rows are inserted into mapping index rowset Q4577836 KB4577836 January 20, 2021
• 4577591 FIX: Widerow insert to an external table is not supported when the row width is more than 32K in SQL Server 2019 Q4577591 KB4577591 January 20, 2021
• 4577590 FIX: Error occurs when row width is less than DMS buffer size of 32K and an incorrect return path is chosen in SQL Server 2019 Q4577590 KB4577590 January 20, 2021
• 4577562 FIX: Istio proxy fails as automountServiceAccountToken is set to FALSE in CU5 for SQL Server 2019 Q4577562 KB4577562 January 20, 2021
• 4577561 FIX: Error occurs when you try to filter the members of an entity for numeric values less than or greater than '0' in MDS 2019 Q4577561 KB4577561 January 20, 2021
• 4576778 FIX: Table Variable Deferred Compilation feature on SQL Server 2019 database remains enabled when database compatibility level is 140 or lower Q4576778 KB4576778 January 20, 2021
• 4575453 FIX: SQL Server does not start when remote admin connections are enabled and IPV6 is disabled on the host Q4575453 KB4575453 January 20, 2021
• 4575275 FIX: Access violation occurs when MSTVF references an In-Memory OLTP large-value data type with interleaved execution enabled in SQL Server 2019 Q4575275 KB4575275 January 20, 2021
• 4574801 FIX: Incorrect results occur when you run PolyBase query to read text files from Hadoop in SQL Server 2019 Q4574801 KB4574801 January 20, 2021
• 4570679 FIX: Remote Hadoop bridge fails when using Hadoop connectivity levels other than seven in SQL Server 2019 on Linux Q4570679 KB4570679 January 20, 2021
• 4570571 FIX: Query slowness may occur when CPU-intensive SQL Server system tasks run in SQL Server 2019 Q4570571 KB4570571 January 20, 2021
• 4570433 FIX: "Culture is not supported" error or wrong results occur when you run PolyBase query in SQL Server 2019 Q4570433 KB4570433 January 20, 2021
• 4570355 FIX: Error occurs when you insert data from one replicated BDC data pool table to another in SQL Server 2019 Q4570355 KB4570355 January 20, 2021
• 4569425 FIX: Transactional replication publications can support URL type device to initialize subscriptions from backups in Azure Blob Storage in SQL Server 2017 and 2019 Q4569425 KB4569425 January 20, 2021
• 4569424 FIX: Intermittent Availability Group failover occurs as AG helper connection times out while connecting to SQL Server Q4569424 KB4569424 January 20, 2021
• 4568653 FIX: INSERT EXEC doesn't work when you insert row containing explicit identity value into table with IDENTITY column and IDENTITY_INSERT is OFF by default in SQL Server Q4568653 KB4568653 January 20, 2021
• 4564876 FIX: Unable to reconfigure Database mirroring when ADR is enabled and disabled in SQL Server 2019 Q4564876 KB4564876 January 20, 2021
• 4564868 FIX: Assertion exception occurs when you query the DMV sys.dm_db_file_space_usage in SQL Server 2017 and 2019 Q4564868 KB4564868 January 20, 2021
• 4563597 FIX: Assertion dump may occur when Implicit Transactions are enabled in SQL Server 2019, 2017, and 2016 Q4563597 KB4563597 January 20, 2021
• 4563195 FIX: sp_execute_external_script may fail to run R scripts that use the RxLocalParallel compute context or the doParallel R package in SQL Server 2019 Q4563195 KB4563195 January 20, 2021
• 4563044 FIX: Allow external resource pool to use more than one processor group in SQL Server 2019 on Windows Q4563044 KB4563044 January 20, 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 20, 2021
• 4562618 FIX: Changes to firewall rules created when you install PolyBase in scale-out group configuration in SQL Server 2019 Q4562618 KB4562618 January 20, 2021
• 4562173 FIX: Availability Group failover generates lot of dumps as DTC support is toggled between PER_DB and NONE multiple times Q4562173 KB4562173 January 20, 2021
• 4561915 Improvement: MAXTRANSFERSIZE no longer required to enable backup compression on TDE encrypted databases Q4561915 KB4561915 January 20, 2021
• 4560183 FIX: Distributed transactions may experience long waits with DTC_STATE wait type in SQL Server Q4560183 KB4560183 January 20, 2021
• 4560051 FIX: SQL Server may still read data from secondary replica when ALLOW_CONNECTIONS is set to NO Q4560051 KB4560051 January 20, 2021
• 4556244 FIX: Credential update frequency option is added to mssql-conf option in SQL Server 2019 on Linux Q4556244 KB4556244 January 20, 2021
• 4556233 FIX: Setup is unable to extract product update when it is executed as LOCAL SYSTEM with UPDATE SOURCE option specified in SQL Server 2019 Q4556233 KB4556233 January 20, 2021
• 4555232 FIX: Blocking may occur when Reduce Recompilations feature is enabled by default in SQL Server 2019 Q4555232 KB4555232 January 20, 2021
• 4552205 FIX: Error occurs when you try to create external table in PolyBase with database_default as collation in SQL Server 2019 Q4552205 KB4552205 January 20, 2021
• 4552159 FIX: Error occurs when you apply a security policy on PolyBase external table in SQL Server 2019 Q4552159 KB4552159 January 20, 2021
• 4551838 FIX: Memory leak by Controller container in SQL Server 2019 BDC Q4551838 KB4551838 January 20, 2021
• 4551781 Update terms of use for SQL Server 2019 Q4551781 KB4551781 January 20, 2021
• 4551221 FIX: Error occurs when you try to create a differential backup on secondary replica in SQL Server Q4551221 KB4551221 January 20, 2021
• 4551220 FIX: Assertion error occurs when you run resumable index build statement in SQL Server Q4551220 KB4551220 January 20, 2021
• 4550657 FIX: Error occurs when you interact with SQL Server Agent in SQL Server 2019 Q4550657 KB4550657 January 20, 2021
• 4548133 FIX: Data length/size of Unicode nvarchar data type column is not correct for OutputDataSet in sp_execute_external_script query in SQL Server 2019 on Linux Q4548133 KB4548133 January 20, 2021
• 4548131 FIX: Fail to access openmpi path when running rx jobs in parallel mode with Revo package in Linux SQL Server 2019 Q4548131 KB4548131 January 20, 2021
• 4548103 FIX: Performance degradation occurs on PMEM devices with Hybrid Buffer Pool enabled in SQL Server 2019 Q4548103 KB4548103 January 20, 2021
• 4543027 FIX: Parallel sampled filtered statistics may cause incorrect histogram scaling in SQL Server Q4543027 KB4543027 January 20, 2021
• 4541770 FIX: Assertion failure occurs when persistent log buffer is used in SQL Server Q4541770 KB4541770 January 20, 2021
• 4541762 FIX: Management Data Warehouse Server Activity Collection Set may fail in SQL Server Q4541762 KB4541762 January 20, 2021
• 4541724 FIX: Intermittent non-yielding scheduler occurs when memory-optimized database running under heavy I/O activities in SQL Server Q4541724 KB4541724 January 20, 2021
• 4541520 FIX: Assertion occurs when you process a malformed XML message sent as message in Service Broker queue in SQL Server Q4541520 KB4541520 January 20, 2021
• 4541435 FIX: Error occurs when you rename a column on temporal current table in SQL Server Q4541435 KB4541435 January 20, 2021
• 4541309 FIX: Missing log block may occur when you use Always On availability group in SQL Server Q4541309 KB4541309 January 20, 2021
• 4541300 FIX: Fix incorrect values in auto seeding XEvents in SQL Server Q4541300 KB4541300 January 20, 2021
• 4541096 FIX: Access Violation occurs when you run query on computed columns in SQL Server Q4541096 KB4541096 January 20, 2021
• 4540901 FIX: SQL Server may terminate due to lock conflicts during error message processing in SQL Server 2016, 2017 and 2019 Q4540901 KB4540901 January 20, 2021
• 4540896 FIX: Access violation may occur when enumerating files in a FileTable in SQL Server Q4540896 KB4540896 January 20, 2021
• 4540449 FIX: Error occurs in sp_xml_preparedocument where MSXMLSQL tries to access virtual address space beyond limit in SQL Server 2016, 2017 and 2019 Q4540449 KB4540449 January 20, 2021
• 4540372 FIX: XML PATH queries in PolyBase fail with an error in SQL Server 2019 Q4540372 KB4540372 January 20, 2021
• 4540371 FIX: Query on Clustered Columnstore Index in SQL Server 2019 uses more CPU time than in SQL Server 2016 Q4540371 KB4540371 January 20, 2021
• 4540346 FIX: MERGE statement fails with assert “Attempt to access expired blob handle (1)” in SQL Server 2016, 2017 and 2019 Q4540346 KB4540346 January 20, 2021
• 4540342 FIX: Non-yielding scheduler condition occurs with CONNECTION_MANAGER spinlock in SQL Server Q4540342 KB4540342 January 20, 2021
• 4540121 FIX: sp_execute_external_script doesn't run when you install SQL Server 2019 with Machine Learning Services and a customized Shared feature directory Q4540121 KB4540121 January 20, 2021
• 4539880 FIX: Access violation occurs with wait_info XEvent on busy SQL Server Q4539880 KB4539880 January 20, 2021
• 4539815 FIX: Access violation occurs when change tracking auto cleanup tries to clean up side tables in SQL Server Q4539815 KB4539815 January 20, 2021
• 4539203 FIX: Error occurs when you use PolyBase Generic ODBC connector with backend that has unsupported quote character in SQL Server 2019 Q4539203 KB4539203 January 20, 2021
• 4539201 FIX: XML queries in PolyBase fail with an unknown type error in SQL Server 2019 Q4539201 KB4539201 January 20, 2021
• 4539200 FIX: Internal DMS error when you use PolyBase Generic ODBC connector in SQL Server 2019 Q4539200 KB4539200 January 20, 2021
• 4539199 FIX: PolyBase defaults string mapping for Microsoft Spark ODBC driver in SQL Server 2019 Q4539199 KB4539199 January 20, 2021
• 4539198 FIX: Map large fixed width types to variable width types in PolyBase in SQL Server 2019 Q4539198 KB4539198 January 20, 2021
• 4539197 FIX: Null pointer exception error occurs when "latch_suspend_end" XEvent is enabled in SQL Server 2019 Q4539197 KB4539197 January 20, 2021
• 4539172 FIX: Launchpad services fails to start during failover in SQL Server 2019 Q4539172 KB4539172 January 20, 2021
• 4539023 FIX: Analysis Services Execute DDL task fails to impersonate the user context to the remote Analysis services instance in SQL Server 2017 and 2019 Q4539023 KB4539023 January 20, 2021
• 4539000 FIX: SSMS showplan error occurs for BDC query in SQL Server 2019 Q4539000 KB4539000 January 20, 2021
• 4538978 Improvement: Add BDC storage pool cache in SQL Server 2019 Q4538978 KB4538978 January 20, 2021
• 4538968 FIX: PolyBase query execution time may increase exponentially when you run concurrent queries in SQL Server 2019 Q4538968 KB4538968 January 20, 2021
• 4538858 FIX: Dumps occur because of OOM condition in SQL Server 2019 Q4538858 KB4538858 January 20, 2021
• 4538849 FIX: Transaction commit delay time is higher under low usage workloads in SQL Server 2017 and 2019 Q4538849 KB4538849 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
• 4538575 FIX: Login and logout failures occur while auditing data classification attributes in SQL Server 2019 Q4538575 KB4538575 January 20, 2021
• 4538573 FIX: Changes made using ALTER DATABASE...SQL Server 2019 fails to log changes in SQL Error log or raise database trigger Q4538573 KB4538573 January 20, 2021
• 4538497 FIX: Slow query performance when using query predicates with UPPER, LOWER or RTRIM with default CE in SQL Server 2017 and 2019 Q4538497 KB4538497 January 20, 2021
• 4538496 FIX: Unable to encrypt data when using column encryption with symmetric keys in SQL Server 2019 Q4538496 KB4538496 January 20, 2021
• 4538495 FIX: Access violation occurs when you create remote stored procedure with one of the system variable (@@servername, @@servicename) in SQL Server 2019 Q4538495 KB4538495 January 20, 2021
• 4538481 FIX: Exception occurs when you run UNION ALL+ORDER BY/MERGE UNION ALL queries on table that contains randomized encrypted data in SQL Server 2019 Q4538481 KB4538481 January 20, 2021
• 4538382 Implement support for Kerberos constrained delegation in SQL Server 2019 on Linux Q4538382 KB4538382 January 20, 2021
• 4538378 FIX: The "is_media_read_only" value remains unchanged for a SQL Server data file even though the media is no longer read-only Q4538378 KB4538378 January 20, 2021
• 4538377 FIX: Non-yielding scheduler condition occurs when you run batch mode query with multiple joins in SQL Server 2017 and 2019 Q4538377 KB4538377 January 20, 2021
• 4538365 FIX: Change Tracking cleanup does not work when invalid cleanup and hardened cleanup version are negative in SQL Server 2017 and 2019 Q4538365 KB4538365 January 20, 2021
• 4538344 FIX: Passwords are masked in audit logs in SQL Server 2019 Q4538344 KB4538344 January 20, 2021
• 4538342 FIX: Latest drivers fail to work with in-memory compiled queries in SQL Server 2019 Q4538342 KB4538342 January 20, 2021
• 4538268 FIX: "Expired BLOB handle" error occurs when cross-database transaction involves communication with MSDTC in SQL Server 2017 and 2019 Q4538268 KB4538268 January 20, 2021
• 4538174 FIX: Error occurs and AG will be in non-synchronizing state when failover happens in primary AG of Distributed Availability Group in SQL Server 2017 and 2019 on Linux Q4538174 KB4538174 January 20, 2021
• 4538164 FIX: Error occurs when you run the same PolyBase query multiple times in SQL Server 2019 Q4538164 KB4538164 January 20, 2021
• 4538163 FIX: PolyBase may fail to generate dumps if an error occurs during the distributed query optimization phase in SQL Server 2019 Q4538163 KB4538163 January 20, 2021
• 4538162 FIX: Unable to start PolyBase services when TCP/IP is not enabled in SQL Server 2019 Developer Edition Q4538162 KB4538162 January 20, 2021
• 4538161 FIX: Error occurs when you run queries in PolyBase scale-out groups in SQL Server 2019 Q4538161 KB4538161 January 20, 2021
• 4538159 FIX: Calculation with summarizecolumn returns unexpected results after upgrading to SSAS 2019 with compatibility level 1500 Q4538159 KB4538159 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
• 4538036 FIX: Error occurs when you query storage pool external table that contains column with money data type in SQL Server 2019 BDC Q4538036 KB4538036 January 20, 2021
• 4538017 FIX: Severe contention on LOGCACHE_ACCESS spinlock in SQL Server 2019 Q4538017 KB4538017 January 20, 2021
• 4537869 FIX: Log shipping agent is not able to log history and error information to SQL Server 2019 Q4537869 KB4537869 January 20, 2021
• 4537751 FIX: Error due to explicit transaction isolation level hint when accessing Memory-Optimized Tempdb catalog views in SQL Server 2019 Q4537751 KB4537751 January 20, 2021
• 4537710 FIX: SOS_BLOCKALLOCPARTIALLIST spin lock contention may occur when TF 834 is enabled in SQL Server 2019 Q4537710 KB4537710 January 20, 2021
• 4537452 FIX: Logreader doesn't execute when you upgrade from SQL Server 2017 to 2019 Q4537452 KB4537452 January 20, 2021
• 4537401 FIX: Custom date format with time doesn't work properly in SQL Server 2019 Master Data Services Q4537401 KB4537401 January 20, 2021
• 4537350 FIX: Access Violation occurs when you run DBCC CHECKTABLE against a table with Clustered Columnstore Index in SQL Server Q4537350 KB4537350 January 20, 2021
• 4537347 FIX: Error 544 occurs when you use SET IDENTITY_INSERT on temp table in SQL Server 2019 Q4537347 KB4537347 January 20, 2021
• 4537072 FIX: Creating an external table against an Oracle database in SQL Server 2019 may fail if using Oracle database 12.2 or later versions Q4537072 KB4537072 January 20, 2021
• 4536841 FIX: Error occurs while creating External Data Source for Data Pool that has nondefault name for LOCATION in SQL Server 2019 Q4536841 KB4536841 January 20, 2021
• 4536684 FIX: Error occurs when QDS is turned on or you generate query plan for Polybase queries in SQL Server 2019 Q4536684 KB4536684 January 20, 2021
• 4536077 FIX: Dump is generated when you create an AG with more than 122 characters in SQL Server 2019 Q4536077 KB4536077 January 20, 2021
• 4534981 FIX: Additional cluster resources are removed by the "azdata bdc delete" command Q4534981 KB4534981 January 20, 2021
• 4534249 FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server Q4534249 KB4534249 January 20, 2021
• 4534148 FIX: PolyBase query may hang if you cancel the query after it is started in SQL Server 2019 Q4534148 KB4534148 January 20, 2021
• 4533497 FIX: External satellite process scripts like R, Python are unable to access any directories outside of their working directory in SQL Server 2019 Q4533497 KB4533497 January 20, 2021
• 4533251 FIX: Upgrading FCI passive node from SQL Server 2019 RC1 to RTM fails when you try to access the MSSQL\JOBS which is on the shared drive Q4533251 KB4533251 January 20, 2021
• 4531384 FIX: Queries may fail in SQL Server 2019 when PolyBase is under stress and heavy cancellations Q4531384 KB4531384 January 20, 2021
• 4531349 FIX: DMVs fail when Big Data Cluster has multiple compute nodes in SQL Server 2019 Q4531349 KB4531349 January 20, 2021
• 4531238 FIX: Heap corruption occurs when ADR is disabled and aborted transactions are present in SQL Server 2019 database Q4531238 KB4531238 January 20, 2021
• 4531232 FIX: PolyBase Engine Service may dump if an error occurs during retrieval of Data Pool metadata in SQL Server 2019 Q4531232 KB4531232 January 20, 2021
• 4531226 FIX: Error occurs when you select from storage pool table and insert into another external table in SQL Server 2019 Q4531226 KB4531226 January 20, 2021
• 4531225 FIX: PolyBase query may hang when DMS restarts in SQL Server 2019 Q4531225 KB4531225 January 20, 2021
• 4531224 FIX: Spurious lines may be added to the SQL Server error log at each initialization in SQL Server 2019 Q4531224 KB4531224 January 20, 2021
• 4531125 Improvement: Update the hktempdb.dll version in SQL Server 2019 Q4531125 KB4531125 January 20, 2021
• 4531049 FIX: Access violation occurs when you set database containment to NONE in SQL Server 2019 Q4531049 KB4531049 January 20, 2021
• 4531029 FIX: Query may fail when you join a storage pool table with a data pool table in SQL Server 2019 Q4531029 KB4531029 January 20, 2021
• 4531026 FIX: NullPointerException occurs when the name node is not active and the HTTP request has other failures in SQL Server 2019 Q4531026 KB4531026 January 20, 2021
• 4531025 Improvement: Update PolyBase vbump to 150.1812.0 in SQL Server 2019 Q4531025 KB4531025 January 20, 2021
• 4531010 FIX: CREATE INDEX with new CE reads the partition table and results in huge row count higher than the total table row count in SQL Server Q4531010 KB4531010 January 20, 2021
• 4530827 FIX: Two issues with remote Hadoop bridge process in SQL Server 2019 Q4530827 KB4530827 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
• 4530769 FIX: FSM may be called when you create a database in SQL Server 2019 Big Data Clusters Q4530769 KB4530769 January 20, 2021
• 4530720 FIX: "The File location cannot be opened" error occurs when you try to open a FileTable directory in SQL Server Q4530720 KB4530720 January 20, 2021
• 4530500 FIX: Assertion dump occurs when sp_cdc_disable_db is executed to disable CDC or when distributed transaction is committed after ROLLBACK SAVEPOINT in SQL Server Q4530500 KB4530500 January 20, 2021
• 4530499 FIX: Non-yielding scheduler error when Polybase function call to shared memory takes long time in SQL Server 2019 Q4530499 KB4530499 January 20, 2021
• 4530496 FIX: Data pool database may be deleted if you fail to drop database on master in SQL Server 2019 Q4530496 KB4530496 January 20, 2021
• 4530475 FIX: IsError function fails to detect error in Excel XIRR function when MDX query is executed from SSIS Q4530475 KB4530475 January 20, 2021
• 4530468 FIX: PolyBase Hadoop queries may fail when the launchpadd service is restarted or killed in SQL Server 2019 Q4530468 KB4530468 January 20, 2021
• 4530443 FIX: Non-yielding scheduler issue occurs in SQL Server when you run an online build for an index that's not partition-aligned Q4530443 KB4530443 January 20, 2021
• 4530427 FIX: sp_describe_parameter_encryption returns different results with different parameter positions in SQL Server 2019 Q4530427 KB4530427 January 20, 2021
• 4530303 FIX: Data masking of user-defined functions may result in crashes in SQL Server 2019 Q4530303 KB4530303 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
• 4530281 FIX: Typo in error message for Columnstore indexes on temporary tables in SQL Server 2019 Q4530281 KB4530281 January 20, 2021
• 4530280 Improvement: Add new fields to latch_suspend_end Extended Event in SQL Server 2019 Q4530280 KB4530280 January 20, 2021
• 4530259 FIX: Scripts generated by SSMS collect different wait types after you install SQL Server Q4530259 KB4530259 January 20, 2021
• 4530251 FIX: Error 8601 occurs when you run a query with partition function in SQL Server Q4530251 KB4530251 January 20, 2021
• 4530212 FIX: Access violation occurs when you use sys.dm_os_memory_objects in SQL Server Q4530212 KB4530212 January 20, 2021
• 4530097 FIX: Package execution may be impacted in SQL Server 2019 Integration Services Q4530097 KB4530097 January 20, 2021
• 4530084 FIX: Error occurs when you try to install SQL Server 2019 on a low power CPU Q4530084 KB4530084 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
• 4530055 FIX: Access violation occurs when worker stealing is enabled and CPU capacity reaches maximal configured value in SQL Server 2019 Q4530055 KB4530055 January 20, 2021
• 4530054 FIX: Worker stealing stops working when AG contains one or more encrypted databases in SQL Server 2019 Q4530054 KB4530054 January 20, 2021
• 4529944 FIX: Unsigned files are installed through the Microsoft MPI in SQL Server 2019 Q4529944 KB4529944 January 20, 2021
• 4529942 FIX: Restore fails when you try to restore compressed TDE backups prior to SQL Server 2016 SP2 CU4 on SQL Server 2016 SP2 CU8 Q4529942 KB4529942 January 20, 2021
• 4529927 FIX: .NET Framework DbDataAdapter.FillSchema method returns NULL on database with compatibility level 140 in SQL Server 2019 and 2017 Q4529927 KB4529927 January 20, 2021
• 4529893 FIX: Audit of batch may be skipped when the batch causes a failure that closes the session in SQL Server 2019 Q4529893 KB4529893 January 20, 2021
• 4529848 FIX: PolyBase DMVs may return unexpected results after changing PolyBase enabled setting in SQL Server 2019 Q4529848 KB4529848 January 20, 2021
• 4529833 FIX: sp_describe_parameter_encryption returns different results if you switch parameter positions in SQL Server 2017 and 2019 Q4529833 KB4529833 January 20, 2021
• 4528492 FIX: DTC transaction scenario reports unsupported transaction error when HkTempdb transaction is used in SQL Server 2019 Q4528492 KB4528492 January 20, 2021
• 4528491 FIX: Access violation occurs when you call HkError.Throw() in SQL Server 2019 Q4528491 KB4528491 January 20, 2021
• 4528490 FIX: Access violation occurs when attempting to fetch the IAM page of the table in SQL Server 2019 Q4528490 KB4528490 January 20, 2021
• 4528337 FIX: Assertion error when you run internal query in batch mode for populating full-text index on computed LOB in SQL Server 2019 Q4528337 KB4528337 January 20, 2021
• 4528250 FIX: Assertion error occurs when you use IDENT_CURRENT on view that has identity columns in SQL Server Q4528250 KB4528250 January 20, 2021
• 4528168 FIX: Using temporary tables across multiple scopes may cause Error 213 or access violation in SQL Server 2019 Q4528168 KB4528168 January 20, 2021
• 4528139 FIX: "Debug Assertion Failed" error if you create objects that are not hashed by name in SQL Server 2019 Q4528139 KB4528139 January 20, 2021
• 4528097 FIX: Access violation occurs when you query sys.dm_db_persisted_sku_features DMV in SQL Server 2019 Q4528097 KB4528097 January 20, 2021
• 4528067 FIX: Error 8959 may occur on IAM page when you query sys.dm_db_index_physical_stats against partitioned columnstore table after partition switch in SQL Server Q4528067 KB4528067 January 20, 2021
• 4528066 FIX: Unable to restore SQL Server 2012 databases on SQL Server 2016, 2017 and 2019 because of NCCI Q4528066 KB4528066 January 20, 2021
• 4527916 FIX: You may receive incorrect object_id after you switch a partition in SQL Server 2017 and 2019 Q4527916 KB4527916 January 20, 2021
• 4527716 FIX: You may encounter a non-yielding scheduler condition when you run query with parallel batch-mode sort operator in SQL Server Q4527716 KB4527716 January 20, 2021
• 4527538 FIX: "A system assertion check has failed" error when a procedure call is made from CLR with an OUTPUT large object argument Q4527538 KB4527538 January 20, 2021
• 4527510 FIX: User hierarchy is not hidden when you run DISCOVER_CSDL_METADATA in SQL Server Q4527510 KB4527510 January 20, 2021
• 4527355 FIX: Synchronized job may fail when the target servers start to synchronize the database in SQL Server Q4527355 KB4527355 January 20, 2021
• 4527229 FIX: UPDATE STATISTICS takes very long time to generate maintenance plan for large databases in SQL Server Q4527229 KB4527229 January 20, 2021
• 4527165 FIX: SQL Server Browser doesn't respond through clustered IP address from a SQL Server 2019 Failover Clustered Instance (FCI) Q4527165 KB4527165 January 20, 2021
• 4526315 FIX: Database cannot recover and reports error 5243 in SQL Server Q4526315 KB4526315 January 20, 2021
• 4525483 FIX: Exception error 3628 may occur when you run stored procedure in SQL Server Q4525483 KB4525483 January 20, 2021
• 4524542 FIX: MDS and/or LocalDB patch installation fails if you patch SQL Server with a next CU Q4524542 KB4524542 January 20, 2021
• 4524191 FIX: Menu and scroll bar are missing in "Changes" section when large number of changesets are added in Excel add-in for MDS in SQL Server 2017 and 2019 Q4524191 KB4524191 January 20, 2021
• 4523102 FIX: SQL Server database remains in frozen I/O state indefinitely when backed up by VSS Q4523102 KB4523102 January 20, 2021
• 4522002 FIX: SQL Server 2017 and 2019 on Linux fails with an Assertion error Q4522002 KB4522002 January 20, 2021
• 4521960 FIX: Access violation occurs when a clone database verification fails in SQL Server 2016, 2017 and 2019 Q4521960 KB4521960 January 20, 2021
• 4521702 FIX: ObjectPropertyEx Cardinality property for columnstore table doesn't include rows in delta store rowset or account rows in deleted bitmap rowset in SQL Server 2019 Q4521702 KB4521702 January 20, 2021
• 4521659 FIX: SQL Writer Service fails to back up in non-component backup path in SQL Server 2016, 2017 and 2019 Q4521659 KB4521659 January 20, 2021
• 4519796 FIX: Stack dump occurs when table type has a user-defined constraint in SQL Server 2016, 2017 and 2019 Q4519796 KB4519796 January 20, 2021
• 4519668 FIX: Access violation occurs when you enable TF 3924 to clean orphaned DTC transactions in SQL Server 2016, 2017 and 2019 Q4519668 KB4519668 January 20, 2021
• 4519366 FIX: Incorrect results occur with index intersection on partitioned table with a clustered columnstore index in SQL Server Q4519366 KB4519366 January 20, 2021
• 4518364 FIX: Access violation occurs when you run queries that involve PIVOT or UNPIVOT in SQL Server 2016, 2017 and 2019 Q4518364 KB4518364 January 20, 2021
• 4517771 FIX: Orphaned CLR sessions cause blocking in SQL Server Q4517771 KB4517771 January 20, 2021
• 4516999 FIX: File content is sent twice when copied to HDFS using Hadoop File System Task in SQL Server 2017 and 2019 Q4516999 KB4516999 January 20, 2021
• 4511771 FIX: Full-Text search auto crawl stops when AG goes offline in SQL Server Q4511771 KB4511771 January 20, 2021
• 913945 Microsoft does not certify that third-party products will work with Microsoft SQL Server Q913945 KB913945 January 20, 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
• 4594205 "Attempted to perform an unauthorized operation" error when you set up or update SQL Server instances Q4594205 KB4594205 January 13, 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 13, 2021
• 4577837 FIX: Queries fail if storage pool caching is enabled by default in SQL Server 2019 Big Data Cluster Q4577837 KB4577837 January 13, 2021
• 4577594 FIX: Add language and extension directories to the PATH environment variable in SQL Server 2019 Q4577594 KB4577594 January 13, 2021