primary key

Why UUIDv7 does not reduce fragmentation in SQL Server

UUIDv7 places its timestamp first, but SQL Server compares uniqueidentifier values starting from the last bytes. Measured on 25,000 inserts: no gain over NEWID().

LOB replication with GoldenGate and importance of primary keys

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I(…)

GoldenGate row identification: misconceptions and solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)