The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Breaking down those ‘weird’ problems
This month, my good friend and fellow Dune-fan Joe Fleming (@muaddba.bsky.social) from SQL Tailor Consulting asks us about weird problems, and in particular, how we

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
Breaking down those ‘weird’ problems
This month, my good friend and fellow Dune-fan Joe Fleming (@muaddba.bsky.social) from SQL Tailor Consulting asks us about weird problems, and in particular, how we
Managing SQL Agent Jobs
There are some things I really like about SQL Agent Jobs, which is why I’m secretly quite fond of this month’s T-SQL Tuesday topic, from
A quick video about SSMS 21’s scroll bar
Erik Darling insisted on a video for T-SQL Tuesday this month. If you’re more of a text person… The video shows how you can get
Mentoring
Mentoring is one of the ways I like to sow into the technical community. I feel like the community is much more about the individuals
Permissions and Security Health Checks
Steve Jones (@way0utwest@bluesky), who has coordinated the T-SQL Tuesday blog party since Adam Machanic stepped down, is also hosting this month. And he asks us
Round-up for T-SQL Tuesday 182 – Integrity
I was the host for T-SQL Tuesday this month, inviting people to write about integrity. And because I don’t believe in just providing a list