I'm just hoping that Microsoft will get around to implementing the ANSI/ISO standard null first or last subclause that goes after the sorting direction. Since it applies column by column, rather than a server-wide setting. You can adjust to what you need. As a flashback to the old days, this is why we used to use all nines or all zeros for the encodings that we wanted to sort always first are always last back in the punchcard days.
Please post DDL and follow ANSI/ISO standards when asking for help.