The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
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
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
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
Tuning Using Window Functions
Sometimes query tuning involves taking a different approach to a problem. And given that other tuning options might be creating index(es) or redesigning tables –