I read with interest this article in SQL Server Central about working with JSON data in SQL Server. The Polaris folks encountering JSON in logs or anyone working with JSON in OpenRefine may find this useful. Enjoy!
Could be handy! I know for Polaris at least the InnReach/Rapdio log data does get stored as JSON and the DB compatibility level for our instance of the database meets the requirements, so this could be helpful and mean one less need to copy / paste into a JSON formatter when attempting to interpret logs.