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
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
Hekaton – the bad and the good, and a misconception
The SQL Server platform is a robust system, designed to handle data in a relational system through the “ACID” properties of transactions. That is, to
My last ticket
There are a bunch of different things I do for clients, so it’s a bit strange to try to think what to write about in
Kelly Broekstra, MVP
It’s not hard to see why Kelly has been recognised as a Microsoft Most Valued Professional, as she did last week. I think everyone who
Responding to cancelled projects
This month (welcome to 2024, by the way) Reitse Eskens (@2meterDBA) asks us about our failures. Our abandoned projects. More specifically, what we’ve learned from
A time for gratitude
First a quick disclaimer. The timing of this is because saying thank is the theme for this month’s T-SQL Tuesday, hosted by Kay Sauter. But