Altering a fixed-width column on a large table can often mean either a lot of planning or a lot of downtime, but in some scenarios there may be an easy out.

We had a case where we increased a varchar column's size, ONLINE, but it caused significant downstream effects. See why.

There are some limitations with STRING_SPLIT that could be overcome, but the cleanest solution might be to add a new function altogether.

My daughter surprised me with a question about work last week, and I answered her by invoking Taylor Swift.

Find out about the replacement I wrote for the undocumented, unsupported, and ill-advised system procedure, sp_MSforeachdb.

A quick update on some maintenance I performed on the site over the weekend.