Be careful with table updates

Posted on 1 December 202121 November 2021 by randolph

The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need to audit changes to a database. This is even more important now as SQL Server 2022 approaches, with its new system-versioned ledger tables which record everything.
-> Continue reading Be careful with table updates

flat lay photography of purple and red leaves

The XML data type is not immutable

Posted on 4 December 20193 December 2019 by randolph

Immutability In many programming languages, strings of text are immutable, meaning they don’t change. When you modify a string, a new string is created in memory by copying the original. The old string stays in memory unless some process removes it. This might be a manual process of de-allocating that memory, or garbage collection if
-> Continue reading The XML data type is not immutable