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

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
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
How much does that primary key or foreign key matter?
I am NOT suggesting that data integrity is irrelevant. Not at all. But how often do we need an enforced primary key or foreign key?
T-SQL Tuesday Invitation #182 – Integrity
It’s my turn to host T-SQL Tuesday again. It’s been a while for me. I think the last time was when the topic was Plan