The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Speaker diversity
I was really pleased to have a session accepted for the PASS Data Community Summit in Seattle this coming November. The acceptance email said that

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
Speaker diversity
I was really pleased to have a session accepted for the PASS Data Community Summit in Seattle this coming November. The acceptance email said that
Coding standards or values?
As a consultant, I see code written in plenty of different organisations. Some of them have rules about their code, and many don’t. I have
New website, thanks to Paper Sword B2B
It’s so exciting! In case you haven’t noticed, you’re reading this on a new design now. And if you followed a URL that was in
My first technical job
Technically my first job was in newspaper delivery, but Ken Fisher (@sqlstudent144)’s challenge is to write about my first technical job, which came much later.
Advice about T-SQL for beginners
Following on from my last post… what advice would I give about T-SQL to my younger-self? Well, for that I’m going back a long way.
Advice, wasted on the young
In 1997, Baz Lurhmann released a song called “Wear Sunscreen“, based on text written by Mary Schmich (although I had to look that up). It