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
Why I like “IS [NOT] DISTINCT FROM”
This month, Deepthi Goguri (@dbanuggets) asks us about our favourite new feature in SQL Server 2022 or Azure. And while there are always a few,
Ignoring best-practice
“If best-practice was always worth following, they’d take the option away.” I don’t know who said this – certainly it’s something that I’ve said before.
Happy End of Year!
I remember two years ago when 2020 ended, people figured life would return to how it was in the beforetimes. Here we are two years
sp_invoke_external_rest_endpoint is a game changer!
This internal procedure is new in Azure SQL DB in 2022. I think it presents a significant change to the way we do things in
Production-Grade Code
Tom Zika (@Zikato25) asks “What quality makes code production grade?“ And… I’m not sure I know the answer. I’m a consultant, so I see quite
The dangers of Dynamic SQL and how to avoid them
That’s “Dynamic SQL”, with a capital D, because I feel like it’s a thing in its own right and deserves to be in Title Case.