Post image

The Transaction Log Is Very Resilient

Last week I wondered whether a log backup chain would survive a database migration. Unsurprisingly, the answer is “yes”. I also asked if a log backup taken on the new instance would be usable on the old instance, if the need arose to fail back to the original environment. Unsurprisingly, the answer is “it depends”.[…]

Post image

Career Limiting Moves – Dropping a Table

In this new series, I will share some things that took place early in my career that could have resulted in my looking for new work—but didn’t! This post is also evidence that I haven’t always worked with SQL Server. I used to work with a PeopleSoft implementation partner, sometime last century. One morning I[…]

Post image

Assumption Sandwich

Today we went live with a product we’ve been working on for A Long Time, in which a team of five has put in A Lot Of Work. During the walk-through with the customer, loading their initial data onto the production system, we had error after error when trying to insert a particular kind of[…]