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.
The "Don't Repeat Yourself" principle suggests that you should reduce repetition. This week I came across a case where DRY should be thrown out the window. There are other cases as well (for example, scalar functions), but this one was an interesting one involving Bitwise logic.