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

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
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
When should your user group meet?
This is a tough question. No matter what kind it is, finding the right time for a group of people to meet is hard. Even