Itzik Ben-Gan takes an interesting look at new bit manipulation functionality in SQL Server 2022, including GET_BIT, SET_BIT, RIGHT_SHIFT, and LEFT_SHIFT.
Paul White explains how and when lock escalation is triggered in SQL Server, clarifying misleading information you may have seen in official documentation and other sources.