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
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
Spatial data from shapefiles (for T-SQL Tuesday #006)
I’m giving a presentation on May 12th at the Adelaide .Net User Group, around the topic of spatial data, and in particular, the visualization of
Presentations about SARGability tomorrow
Tomorrow, via LiveMeeting, I’m giving two presentations about SARGability. That’s April 27th, for anyone reading this later. The first will be at the Adelaide SQL
SQLBits VI – The sixth sets
My involvement stopped with the tagline, but SQLBits VI is on tomorrow. The theme of the event is Performance Tuning, which has nothing to do
Handling special characters with FOR XML PATH(”)
Because I hate seeing > or & in my results… Since SQL Server 2005, we’ve been able to use FOR XML PATH(”) to do string
Exploding maps in Reporting Services 2008 R2 – T-SQL Tuesday #005
Kaboom! Well, that was the imagery that secretly appeared in my mind when I saw “USA By State Exploded” in the list of installed maps