A SQL Server Correlated Subquery Gotcha
Warning: exceptionally geeky post coming up. Those reading for Kindle reviews and other fluffy stuff will want to skip this one… I was hanging out Stack Overflow the other day, and saw a question title that resonated with me: Column does not exist in the IN clause, but SQL runs. It resonated because I’d fallen victim […]
Pretty Poor Security, Apple!
Apple just emailed me someone else’s account name and password. On Monday I got in touch with Apple’s MobileMe “Chat Support” service. I was having a problem with my MobileMe account. Specifically, I’d deleted an event in my local calendar, and it had disappeared from the MobileMe calendar, too, but it was still showing up […]
Books Are Cheap
I’ve been prodded into this post by the recent Agency Pricing announcement on the UK Kindle discussion forums, and subsequent furore. But really this stems from a conversation I had with a friend a couple of weeks ago about e‑book pricing in general. My take on it is this: books are cheap. I believe that […]
Review: Duragadget Kindle 3 Leather Case with Adjustable Stand
In my marathon Kindle 3 review, I bemoaned the price of the official Amazon Kindle case (£30 for the basic version!) Also, though it’s great that I can put the Kindle down on a table and read it — it doesn’t fold itself shut like a paperback would — the slightly-glossier-than-paper screen means it’s more sensitive to viewing angles […]
Serving Websites Using S3 and CloudFront’s Default Root Object
A Better Solution! A couple of years after this blog post was written, Amazon added features to S3/Route 53 to allow static sites with or without the “www” name, so you don’t need to follow the below rather complicated routine. See their blog post on the matter for full details and a walkthrough of the […]