Reverse the order of words in a string in SQL Server

I recently found myself with a situation in SQL Server where I had a string consisting of a series of values (constructed using the CLR function for concatenating values that I wrote about last week) that I needed to reverse.  Unfortunately, it’s not as simple as using SQL Server’s built-in REVERSE function.  That actually reverses each individual character in a string, rather than switching the order of words. Continue reading…

How to open your NAT settings for Xbox LIVE on O2 Wireless Box II

I’ve had my fair share of issues with my broadband connection since signing up with O2 (provided by Be There) 3 years ago. Fortunately, it’s improved a great deal over that time and is now extremely stable. The biggest problem I had was playing online via Xbox LIVE, especially getting my Network Address Translation (NAT) settings right on the supplied O2 Wireless Box II (essentially a rebranded Thomson-Alcatel TG585v7). Continue reading…

Yahoo Site Explorer Closes Tomorrow

For those out there who like to use Yahoo’s Site Explorer to investigate the Yahoo index and mange their sites, the day you’ve been dreading has arrived.  Yahoo have announced the final closure date for the service (after announcing earlier in the year that it would close “sometime this year”) and that day is tomorrow, Monday 21st November.  For managing your own sites, there’s always Bing or Google Webmaster tools but this obviously doesn’t give you the access to other sites on the web.  There are other services out there, like Majestic SEO or SEOmoz but you’re going to have to pay for these.

A sad day for SEOs and web admins everywhere.

Workaround for the Battlefield 3 “no weapon” glitch

In my free time lately I’ve been getting into the superb online multi-player in EA and DICE’s Call of Duty baiter, Battlefield 3 on Xbox 360.  For anyone who’s not tried the series, it’s a large scale multi-player military shooter with wide open maps and a variety of land, sea and air vehicles with which to play.  While it’s enormous fun, especially if your fellow players work as a team it’s unfortunately riddled with game-breaking bugs.  Some players seem worse affected than others and the issues seem to be spread across all three of the game’s platforms; Playstation 3, Xbox 360 and PC. Continue reading…