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, cursors, and scalar functions, they're…

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 why it's suddenly slow, read…

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 but can actually perform just…

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, and being in Australia, I’m…

Figuring out what has changed in a system isn't always easy, so it's a good topic that Meagan Longoria has chosen this month - read the invite and see what…

I like this topic from the legendary Steve Hughes. It’s been a long time since I’ve seen him, but he was always a thoroughly good guy. We both spoke at…

My old friend James Serra asks about what we’ve done where we weren’t sure that things would work out. I'm sure you know I'm a business owner. I’ve had my…

I’m pretty sure both spellings are fine, so don’t come at me for putting an ‘e’ in ‘ageing’. The interwebs tell me the version with the ‘e’ is preferred in…

Louis Davidson is hosting this month's T-SQL Tuesday, and asks us to relive mistakes. Ouch! It's fine - I already had a psychologist appointment scheduled for later in the week.…

Mike Walsh from StraightPath wants us to write two short notes to former selves. One writing now to ten years ago (2025 me to 2015 me), and one writing what…