The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
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
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
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
Career risks?
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
Ageing code
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