The LobsterPot Blog
Insight and opinion from our team of data platform experts.
Featured Blog
Hekaton – the bad and the good, and a misconception
The SQL Server platform is a robust system, designed to handle data in a relational system through the “ACID” properties of transactions. That is, to
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
Christian’s book – not just Brent’s
I like to joke with Christian Bolton (@christianbolton) about the time when he got accused of claiming to have written Brent’s book. Of course, he
PASS Chapter map
Displaying information on an interactive map really isn’t that hard to do. My friends John & Bronwen have been doing this stuff for ages through
What makes a great place to work
Co-incidentally, I’ve been looking for office space for LobsterPot Solutions during the same few days that Luke Hayler (@lukehayler) has asked for my thoughts (okay,
My favourite feature of SQL 2008 R2
Interestingly, my favourite new feature of SQL Server 2008 R2 isn’t any of the obvious things. You may have read my recent posts about how
Buck Woody in Adelaide via LiveMeeting
The URL for attendees is https://www.livemeeting.com/cc/usergroups/join?id=ADL1005&role=attend . This meeting is with Buck Woody. If you don’t know who he is, then you ought to find
Fetching Latitude and Longitude Co-ordinates for Addresses using PowerShell
Regular readers of my blog may be aware that I’ve been doing more and more with spatial data recently. With the now-available SQL Server 2008