The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
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
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
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
Error: Cannot generate SSPI context
I don’t like to write about client situations, but this one seemed worth mentioning for the sake of other people experiencing the same thing, so