There are people out there who struggle to remember the correct order in which to specify T-SQL commands in Microsoft SQL Server.  While I’m not actually one of them, I did like this nice little mnemonic from guest columnist Andy Owl over at SQL Server mega-resource, SQL Server Central.

Self-confessed social “anti-network” site OneTrueFan has recently launched a new API, currently in beta, which provides a staggering level of access to their “Fanalytics” data.

OneTrueFan works via a combination of Facebook/Twitter integration and a custom browser add-on, which tracks your browsing behaviour.  By tracking which pages you visit, what content you share and what you post about, OneTrueFan can compare and rank all their users and offer valuable insight into users’ online behaviour.

A lot of my job as a software developer for a digital marketing company involves investigating new tools and finding out ways of analysing websites and their content, usage and trends.  As such, my team are always discussing new things we can explore and coming up with new ways of looking at the web.

We’ve discussed sentiment analysis many times before, checking keywords or site content to determine whether what’s being said is in a positive of negative tone.  One of our discussions today resulted in one of the guys finding uClassify’s Sentiment Classifier.