Once upon a time, a colleague asked me to look into a customer database with weird spikes in database log usage. (You might start to wonder why I a...
As string is the most common data type in an application, nvarchar and its variant varchar are probably the most common column types in your...
A colleague asked me yesterday – how do we migrate properties of catalog content. There is, unfortunately, no official way to do it. There are...
If you are using Optimizely Customized Commerce, the common wisdom is that you should be using serializable cart mode. It’s not perfect (we discuss...
While we always want to have fast database queries, it is not doable all the time. Sometimes we need to run slow queries, and we need to tell the...