Month: January 2009
Apollo Newspapers – Daily Mail, 9 July 1969
As I posted yesterday, I’ve started scanning my collection of Apollo newspapers. I’m starting with the Apollo 11 newspapers. The Daily Mail released a few pullout sheets about the moon mission. They were called “Moon Mail”. Here is…
Read More »Scanning my newspapers from the Apollo Program
I’ve got a bit of a collection of newspapers from the Apollo program in 1969. Today, I finally started the task of scanning these papers. Some of them require up to 10 scans before being joined back together…
Read More »SQL Tips – Saving Changes Not Permitted
If you’re new to SQL 2008, you’ve probably seen the following message: The error reads: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made…
Read More »SQL Performance – Using LOWER() on case insensitive collations
Take a look at the following SQL. SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = ‘john’SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = ‘john’ The above SQL is Syntactically correct. But, and this is a big but, unless…
Read More »I'm Back!
Sorry about the delays between posts but I’ve been on holiday. I got back from two weeks in sunny New Zealand today so should be posting regularly within a couple of days.
Read More »Happy Birthday Spirit
Back in early 2004, NASA sent two rovers to Mars. The rovers were named Spirit and Opportunity. As of today, the 3rd January 2009, Spirit has now been on the surface of Mars for 5 years. This is…
Read More »Happy New (long) Year
It’s now 2009. Leap days aside, did you notice that 2008 was a little longer than usual? It was a second longer. Midnight on New Years eve (in UTC) went something like 23:59:58, 23:59:59, 23:59:60, 00:00:00, 00:00:01 The…
Read More »