The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Happy end of 2024
As we approach the end of another remarkable year at LobsterPot Solutions, it’s time to reflect on our journey, celebrate our achievements, thank our customers,
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
Happy end of 2024
As we approach the end of another remarkable year at LobsterPot Solutions, it’s time to reflect on our journey, celebrate our achievements, thank our customers,
That time Microsoft gave me a neat Christmas present
Nine Christmases ago, in late November 2015, Microsoft released Service Pack 3 for SQL Server 2012, and included a gift just for me! Only kind
Error: Cannot generate SSPI context
I don’t like to write about client situations, but this one seemed worth mentioning for the sake of other people experiencing the same thing, so
Good Enough is Good Enough
The French philosopher Montesquieu wrote, “Le mieux est le mortel ennemi du bien”, which means, “The best is the mortal enemy of the good.” Montesquieu
Recommended steps for connecting to source data and creating a new Power BI report
Tip: Don’t do it, do this instead In this series of blog posts, I want to explain different ways to extrapolate business requirements to write
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