The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
SQL Server 2025 excitement – fuzzy is coming!
The smart money is on SQL Server 2025 being released to General Availability this month. Next week there are two major conferences in the Microsoft
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
SQL Server 2025 excitement – fuzzy is coming!
The smart money is on SQL Server 2025 being released to General Availability this month. Next week there are two major conferences in the Microsoft
String parsing
Steve Jones asks how we parse strings. As Steve writes, there are a bunch of ways to parse strings in SQL. And (which Steve doesn’t
Learning new skills
Todd Kleinhans asks us to write about “Mastering A New or Existing Technical Skill”. Todd is one of my favourite people in the data community
AI’s impact on careers
Taiob Ali is asking how AI is changing our careers. It’s a good question – one question worth reflecting on, even if the general perception
The younger generation in the SQL community
John Sterrett asks us where the next generation is. Well, not quite. He asks us what we’re doing, or could be, to encourage younger people
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