KB5049235: Cumulative Update 30 for SQL Server 2019

KB5049235 - Cumulative Update 30 for SQL Server 2019

Improvements and fixes included in this update

3588885
Fixes a data discrepancy issue that you encounter when extracting data for Google BigQuery by using the Simba ODBC driver.

3542238
Reduces the HADR_SYNC_COMMIT waits caused by the delay between the log_block_pushed_to_pool and hadr_log_block_capture steps in Always On availability group data movement under certain workloads.

3560254
Fixes an issue in which some availability group (AG) databases are in a non-synchronized state after the Windows Server Failover Clustering (WSFC) quorum loss. After applying the fix, the databases should be able to switch to a resolving state when the persisted configuration data can't be read because of the WSFC quorum loss.

3487110
Fixes an issue that causes database corruption if a system failure with alternatewritethrough mode occurs.

3420397
Fixes an issue in which running queries with columnstore indexes is stuck because of non-yielding scheduler errors.

3514743
Fixes various assertion failures (for example, Location: sosmerge.cpp:2930; Expression: mrP->mrpgcnt > 0) that you might encounter when building an index in simple or bulk-logged recovery models with indirect checkpoints because of missing flushes of intermediate data pages.

3545173
Fixes an issue in which remote code executions might be performed by using a dynamic-link library (DLL) planting technique on a SQL Server instance.

3545179
Fixes an issue in which a vulnerability in a SQL Server assembly might allow remote code execution.