The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
AI and SQL
Pinal Dave (@pinaldave), who might always exist in my mind as the person who took me to a KFC in Bengaluru, asks us about how
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
SARGability isn’t about the left-hand side
This month’s T-SQL Tuesday has me caught slightly unawares. I’m in the UK, having come over for SQLBits, and I’m left writing this with only
Time away from a growing company
At LobsterPot, I’m very blessed to have excellent staff working for me. Someone asked me just today why we haven’t grown more than we have
24 Hours of PASS – sargability resources
I just did a talk for 24 Hours of PASS on Sargability. I’ve done this talk before (about five months ago at the user group
Table? No such thing…
No really – hear me out. Of course you create tables, and you query tables, and we say that data is stored in tables. The
Conor Cunningham speaking to the Adelaide SQL Server User Group
The guy behind the Query Optimizer, Conor Cunningham, is speaking on Sep 27 (well, Sep 28 here in Adelaide) to the User Group in a
Something for everyone at the SQLBits Training Day
Of course, the one not to miss is the one I’m doing, on Fixing Queries with Advanced T-SQL Techniques, but actually, they’re all excellent. For