Read a cautionary tale on how I’ve deceived the SSMS, then promptly forgot about it and, in turn, ultimately confused myself.
Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.
Have you ever encountered a situation where you mark the constraint as trusted, but the next day, it’s back to untrusted again? This blog post will help you find the cause.
I’m reminding myself how to set up secure CrossDB access. This blog post includes a nifty diagram and follow-along example.
How can 15 be less than 13? Let’s have a look at this unexpected, but fully documented behaviour.
I’ve come up with an efficient way to monitor only specific data changes in a table.
I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.