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
My Lightning Talk in MP3 format
Download it now via http://bit.ly/RFCollation Lots of people tell me they wish they’d heard my Lightning Talk from the PASS Summit. This was the one
Collation errors in business
At the PASS Summit last month, I did a set (Lightning Talk) about collation, and in particular, the difference between the “English” spoken by people
PowerShell to fetch a SQL Execution Plan
With PowerShell becoming the scripting language of choice for many people, I’ve occasionally wondered about using it to analyse execution plans. After all, an execution
One other thing: Why ‘LobsterPot’?
I get this question a lot. I don’t mean just ‘every so often’, I mean all the time. It would average out to daily, but
PASS Summit North America 2010
My first PASS Summit didn’t let me down. LobsterPot Solutions sent two people to PASS this year – I was joined by Roger, who also
The Incredible Shrinking Execution Plan script
I just got out of my SQLPASS session, and have uploaded the script from that to the LobsterPot site. The following link should get you