The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Temp tables – a blessing or a curse?
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,
Blogs
LobsterPot Blogs
Blog posts by Rob Farley and other LobsterPot Solutions team members.
Popular Blogs
Handling special characters with FOR XML PATH(”)
SARGable functions in SQL Server
The SSIS tuning tip that everyone misses
Temp tables – a blessing or a curse?
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,
SQL 2025 showing crazy-high CPU
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
Signs of potentially-bad code
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
Forgotten skills that could become critical
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,
Detecting changes
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
Presentations with impact!
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