Month: January 2009

SQL Tips – List of New Zealand Towns and Cities

Here is SQL and a text list of the towns and cities in New Zealand. The list is free for all to use for any purpose. The original data was sourced from Wikipedia on Saturday 31 January 2008. If you

Posted in SQL Tips, Tips

SHA256 and higher in SQL Server

As part of a new project I’m doing, I needed to use hashes. A good source of information on hashes is available from wikipedia. SQL has the built in function HASHBYTES but this only supports up to the SHA128 algorithm

Posted in C# Tips, SQL Tips, Tips

Happy Birthday Opportunity

Following on from my earlier post. The Mars rover Opportunity has now been successfully on the martian surface for 5 years. I have information on the Spirit rover on my earlier post (link at top of this one). Information: http://en.wikipedia.org/wiki/MER-B

Posted in General Randomness

SQL Tips – List of US States

Here is SQL and a tab delimited list of the States of the USA for all to use. The original data was sourced from Wikipedia. Please post a comment if you find this useful. Edit: I’ve beed advised that although

Posted in SQL Tips, Tips

Happy Birthday Apple Macintosh

The Apple Macintosh was introduced on the 24th January 1984. Image source: Wikipedia. Happy 25th birthday, you’ve come a long way.

Posted in General Randomness

SQL Tips – List of Countries

Here is SQL and a tab delimited list of Countries for all to use. The original data was sourced from Wikipedia. Note that some countries have single quotes in their names, these need to be escaped for SQL. The SQL

Posted in SQL Tips, Tips

SQL Tips – List of International Dialling Codes (IDC's)

I’ve been working on a new project and needed a list of International Dialling Codes to insert into my database. Here are the results of my work for all to use. The list is supplied as SQL and then tab

Posted in SQL Tips, Tips

Mac OS X – Remote Desktop Client UK Keyboard Bug Fix

I use the Microsoft Remote Desktop Client (Version 2.0.0 Beta 3) to connect to a number of Windows machines from my Mac laptop. There is one very annoying ‘feature’ when using the Remote Desktop Client with a MacBook with a

Posted in Mac OS X Tips

Apollo Newspapers – Daily Mail, 11 July 1969

The Daily Mail released a few pullout sheets about the moon mission. They were called “Moon Mail”. Here is the Moon Mail from 11 July 1969.

Posted in Astronomy

Apollo Newspapers – Daily Mail, 10 July 1969

The Daily Mail released a few pullout sheets about the moon mission. They were called “Moon Mail”. Here is the Moon Mail from 10 July 1969.

Posted in Astronomy