Month: February 2010

Within-group aggregates with another wrinkle.

by

Recently when optimising an SQL query I needed to return a specific subset of records from a large table. The brilliant Common Queries Tree pointed me in the right direction, but the examples didn’t quite cover my specific case. I needed the records with the maximal value of x and the minimal value of y … Read more

Tethering Jolicloud with a Nokia 6500 Classic

by

Yesterday I plugged my Nokia 6500 Classic phone into my Jolicloud powered netbook, told the network manager I was on a Vodafone contract and bang, instant 3G internet access. It could hardly be simpler. Once its set up, you can edit the configuration and see where it’s put the APN and other connection info, and … Read more