[rekabis]

>If you have a reference for UUIDv7 support in MSSQL

There isn’t any AFAIK. What I ran across was SQL that was meant to go into a trigger or something like that to generate a proper UUIDv7 as if MSSQL was creating one.

Hmmm… could have sworn it was featured here on HN, could have sworn I saw it within the last six months, could have sworn I bookmarked it for closer examination. Not finding it in my favourited stories here on HN, and I have even double-checked on Reddit and Lemmy - no bueno. Really frustrating me, because I love UUIDs for their resistance to the incrementing attacks that integer primary keys typically suffer from.

Edit: After a brief Google search this tickles my memory, but not entirely sure if it is the same code I remember looking at: https://github.com/osexpert/GuidPhantom/blob/main/Uuid_v7_v8...