The LobsterPot Blog

“How do you weigh the risk vs the reward of your database design decisions?” asks my old friend Pat Wright. And one of the examples

Writing this, I’m at home but still recovering from open heart surgery at the start of August. I’m working a little, but not full time

Let me say for starters that I’m pleased we have temporary tables. They’re tremendously useful, but often get abused. Compared to obvious villains like NOLOCK,

Yes, you should consider upgrade to SQL Server 2025. But if you use SQL Logins, check this first (and if you’re here to figure out

I feel like I should preface this with a disclaimer. I added “potentially-” to the title, because there are many queries that might seem bad

Koen Verbeeck (with inspiration from Alexander Arvidsson) asks about the scenario of returning to on-prem from the cloud. Koen wonders if it’s a European concern,