KB5048038 - Cumulative Update 17 for SQL Server 2022

KB5048038 - Cumulative Update 17 for SQL Server 2022

Improvements and fixes included in this update

3666640: ( For Windows) Fixes an issue with the business rule item for the domain-based attribute (DBA) option when you use Master Data Services.
3560259: 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.
3615657: Adds trace flag 3478 in SQL Server 2022 to allow the maximum number of parallel redo threads to be increased based on the total number of CPUs. This change aims to restore the same functionality as SQL Server 2016 or later versions if the thread pool is disabled in SQL Server 2022.
3677296 (Linux): Starting in SQL Server 2022 CU17, you can enable Always On availability groups by using a Pacemaker cluster when SQL Server runs as a restricted application with Security-Enhanced Linux (SELinux) enabled.

3086691: (Windows) Adds a server configuration option external xtp dll gen util enabled, which is configured by using sp_configure to enable the Hekaton dynamic-link library (DLL) Generator component for the Hekaton (In-Memory OLTP) feature.
SQL Server compiles and links a DLL for each native compiled table and stored procedure, which contains the native implementation of those objects in C code. Although the Hekaton DLLs are dynamically generated, the files themselves might present some challenges when there's a compliance requirement that enforces code integrity as a criterion.
With the introduction of the Hekaton DLL Generator component for the Hekaton (In-Memory OLTP) feature, regulatory compliance requirements such as code integrity can be met with Hekaton-generated DLLs. In this case, code integrity ensures that the Hekaton-generated DLLs remain intact and unmodified from the time they're created until they're loaded and executed.

3677980 : FIX Scalar UDF Inlining issues in SQL Server 2022 and 2019 (KB4538581)

3653362 :Fixes a performance issue of the SUBSTRING function that you encounter when extensively using the function, such as building indexes on computed columns with expressions that involve calling SUBSTRING.

3572259: (Windows) Fixes error "The XML data type is damaged" thrown by the Replication Log Reader Agent when you update an XML column with XML compression enabled.

3445709, 3538141 ,3686639 :(Windows) Improvement: Microsoft Entra managed identity support for backup and restore database operations and for EKM with AKV in SQL Server on Azure VMs (KB5043526).

3514753 :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.

3616559 : Fixes a performance issue that you might encounter only when sp_lock is called frequently from multiple connections, which might cause a memory leak. The memory isn't cleaned up until you restart the SQL Server service.