The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
What’s in the database detective toolkit?
This is the question posed by Tim Mitchell over at https://www.timmitchell.net/post/2024/10/01/t-sql-tuesday-179-whats-in-your-data-detective-toolkit. The context is around what techniques are used when I’m faced with a new
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
What’s in the database detective toolkit?
This is the question posed by Tim Mitchell over at https://www.timmitchell.net/post/2024/10/01/t-sql-tuesday-179-whats-in-your-data-detective-toolkit. The context is around what techniques are used when I’m faced with a new
It’s the little things…
Sometimes it’s the little things – the small issues that aren’t actually what we do (ie, not data-related, or processes, or whatever) – that drive
Design a really terrific Star Schema by interpreting an existing report
Previously, I’ve written about tips for designing a really great report model from Agile user stories. Catch up on it here (Useful tips for designing
Snapdragon processors for SQL professionals
If you’ve found this post because you’re trying to figure out how to get SQL Server to run locally on a Copilot+ PC with a
Where is the database code managed?
I’m a consultant, so I see a variety of answers to Mala’s question. But her question isn’t exactly “where does the database code live?”, it’s
Advice for my past self
Louis Davidson (@drsql) asks what advice we wish we’d had – particularly when we were starting out first data platform job. I’m not really sure when