Number three due in December

A few months ago, after almost an eight year gap, we decided to try for a third child. Now we only have about six months until the new baby arrives. It’s very cool – we’re just hoping that the baby is born before Christmas.


At school my son is looking at polyhedra (that’s the proper word for polyhedrons – like cubes, tetrahedrons, etc).   The other day he came home with pictures of a dodecahedron (that’s the one with 12 pentagon sides) and an icosahedron (20 triangle sides). The icosahedron is really neat. Each point has 5 edges hitting it, and if you hold it right, you can have 5 sides in a top layer, 5 on the bottom, and 10 around the middle. It’s nicely symmetrical, and it feels familiar. I think the reason it feels so familiar is because if you chop off the corners … Continue reading Isoccerhedron

No File Conversion in Windows Mobile Device Center?

In the days of ActiveSync (which means before I upgraded to Vista), I could connect my mobile device to my laptop, and copy files across from one device to another. This hasn’t changed. But ActiveSync didn’t just COPY the files. It would CONVERT them as well (something WMDC doesn’t do). ActiveSync would convert Pocket Word files to/from .doc files (a problem Nick Randolph has faced too), Pocket Excel files to/from .xls, and also tag PDF files so that my mobile device could view them in Reflow mode. Like the Pocket Office formats (which are must more compact than the Office 2000 … Continue reading No File Conversion in Windows Mobile Device Center?

Documents in SQL Server 2008

One of my favourite aspects of SQL Server 2008 is the fact that you can store documents (well, files) in the database. Annoyingly, this doesn’t seem to be implemented in the June 2007 CTP. There has long been an argument about whether images should be stored in the database or in the file system. The same argument occurs when discussing Word documents, Excel spreadsheets, and all the rest. With SQL Server 2008, the answer is simple – store in the database using a varchar(max)/nvarchar(max)/varbinary(max) type with the FILESYSTEM option. This will store the information in the file system, but still let you … Continue reading Documents in SQL Server 2008

DATE and TIME data types in SQL Server 2008

Sick of using DATETIME to store values which are always going to be the date-part only? Yeah, me too. This is why SQL Server 2008 has new data types called DATE and TIME, which store just the DATE or TIME component of a DATETIME, respectively. Half the size, and much more appropriate if that’s all you need. So now you can picture code like: where cast(thedatetime as date) = ‘2007-06-11’ But please be aware. This kind of query is likely to cause a table scan, just as if you cast a FLOAT to an INT. In this scenario, it would be better to … Continue reading DATE and TIME data types in SQL Server 2008


Debbie Timmins, who I met through the ACS, asked to interview me. If you’re interested to know what she asked, and how I responded, then check out Deb has been involved with the Young IT side of the ACS recently, and we’ve had quite a few conversations about various things. It’s good to have people like Debbie in Adelaide.

Download SQL Server 2008

Katmai is now called SQL Server 2008, and there is a Preview (CTP) available for download now at There are quite a lot of really cool new features (I will try to list some of them over the next few weeks), and it’s definitely worth downloading and giving a try.