Thursday, September 30, 2004

Shelling out cash for web services I just purchased a 2 year Flickr Pro account and made a donation at audioscrobbler / last.fm. I've always been pretty tight shelling out money for web services - which is odd as I spend my day's creating them at Edict. Until the last few years, I'd actually create the tools myself instead of spending the money. However there are so many exciting things happening on the web these days, it is too hard to catch up. I can't recommend Flickr and  audioscrobbler / last.fm enough. Two great products who are worth every penny paid. (And at that, they don't cost nearly enough.) 7:33:13 PM    comment []  trackback []

Mt St Helens webcam. [via Scripting News] 6:36:58 PM    comment []  trackback []

Review sites reviewed. Kevin Kelly - A Review of Review Sites... [via HubLog] 12:54:42 AM    comment []  trackback []

Random Rows in SQL I was pretty frustrated with SQL today attempting to get back five random rows from a table. The problem is that the RAND() function only runs once per execute - not once per row. My solution around it: SELECT TOP 5 * FROM tableName ORDER BY NewID() 12:44:40 AM    comment []  trackback []