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