Replication authentication and stronger password verifiers arrive
CU12 brings 51 fixes, makes Microsoft Entra authentication for replication generally available, and adds iterated, salted password verifiers. Queries using SESSION_CONTEXT might return incorrect results or trigger access violation dumps in parallel plans.
Check the newer update, KB5036343- Incorrect behavior of SESSION_CONTEXT in parallel plans
Key changes 48 changes
- New Linux: SQL Server on Linux gains support for Extensible Key Management.
- New Security Infrastructure: Password verifiers can use an iterated and salted hash process instead of storing only a SHA-512 hash.
- New SQL OS: Trace flag 2616 enables the stack signature feature when a dump occurs, helping avoid multiple dumps for the same exception.