Replication safeguards, SQL engine fixes, and new link tools
SQL Server 2022 CU28 adds replication and database safety checks, fixes a range of engine and integration issues, and adds tools for Azure SQL Managed Instance links. Queries using SESSION_CONTEXT in parallel plans might still return wrong results or cause access violations.
- Incorrect behavior of SESSION_CONTEXT in parallel plans
Key changes 91 changes
- New Methods to access stored data: Trace flag 697 can disable HoBt schema-latch promotion without disabling all superlatching.
- New Methods to access stored data: Trace flag 683 can reduce CPU overhead when latch promotion occurs without counter partitioning.
- New High Availability and Disaster Recovery: Three procedures can restart seeding, repair a broken link, and check database health in multi-database link mode with Azure SQL Manage...