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 the Moon Mail from 9 July 1969.
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 so it’s rather time consuming.
Hopefully now I’ve started I’ll be spurred into finishing it before the 40th Anniversary in 6 months.
I’ll post copies as I digitise them.
Wish me luck…..
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 changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.
You’ve probably done one of the following:
There is a very simple fix to this…
Go to tools > options from the menu bar.
Select “Designers” from the Left Hand Side menu of the options dialog.
Uncheck “Prevent saving changes that require table re-creation”
Click OK
Take a look at the following SQL.
SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = 'john'
The above SQL is Syntactically correct. But, and this is a big but, unless you are using a case sensitive collation, you are wasting a lot of resources.
The following code will work fine when using the default (case INsensitive) collation.
SELECT firstName, lastName FROM tUsers WHERE LOWER(firstName) = 'JoHn' --Mixed case to prove a point
If you don’t believe me, look at the query plan for both queries while using a case insensitive collation.
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.
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 especially impressive as the original mission was only meant to consist of 90 days on the Martian surface.
Happy 5th Birthday Spirit
Since landing on Mars, the two rovers have collectively sent back over 250,000 images to earth and travelled over 21 kilometres.
Opportunity landed on Mars about 3 weeks after Spirit.
Information: http://en.wikipedia.org/wiki/MER-A
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 leap second took place when the seconds got to 60 making the last minute of 2008 a little longer at 61 seconds.
I was in New Zealand and set up my camera to video the event happening on my GPS. New Zealand is currently 13 hours ahead of UTC so this was going to happen at 1pm on New Years Day.
It was a real anti climax:
I’ve since found out that GPS uses a different time system which doesn’t use leap seconds. My only question now is “Are all the videos of leap seconds on GPS’s faked?”.
More information: http://en.wikipedia.org/wiki/Leap_second.
