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 new laptop – with a really nice battery option
It was about time I got a new laptop, and so I made a phone-call to Dell to discuss my options. I decided not to
A whole site for reviewing of SQL Server MVP Deep Dives
This book just keeps amazing me. Not only as I read through some chapters for the first time, and others for the second and third
Re-running SSRS subscription jobs that have failed
Sometimes, an SSRS subscription fails for some reason. It can be annoying, particularly as the appropriate response can be hard to see immediately. There may
T-SQL Tuesday – Query Cost
In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL
SQL community events in Adelaide this week
Two events coming up in the next few days in Adelaide. On Monday 22nd, we see the start of the Australian Azure Launch, with David
Why move a blog?
A few people have asked why I moved to sqlblog.com (I’ve shifted my blog from msmvps.com recently). After all, I had used msmvps.com since 2006