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

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
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
Happy end of 2024
As we approach the end of another remarkable year at LobsterPot Solutions, it’s time to reflect on our journey, celebrate our achievements, thank our customers,
That time Microsoft gave me a neat Christmas present
Nine Christmases ago, in late November 2015, Microsoft released Service Pack 3 for SQL Server 2012, and included a gift just for me! Only kind