How delete all the data in all the tables in your database

Adi has a nice way of removing all the data. The only change I made was to use “DELETE FROM” instead of “TRUNCATE TABLE” so that it works with foreign keys.

My 711CE is dead, long live my 7404GL

It is a sad day - in the last few days, my Billion 711CE had become very unreliable - locking up regularly after a few hours use. It has been so reliable, and I had high hopes that it would keep powering on for another year or so, even after our exchange got upgraded to ADSL2+.

But it wasn’t to be. And seeing as we use VoIP for our phone calls, it is kind of important to have a reliable and stable Internet connection. So I’ve stuck with Billion, and gone for a BiPAC 7402GL purchased from Mark at MATS Systems.

I didn’t need the VGL model, as I already have a Sipura 3000. The features are certainly more advanced than the 711CE could offer. The 11g wireless is a nice bonus, and the extra LAN ports means I can retire my mini-switch for now too (a small power consumption saving there).

Threat Analysis & Modeling v2.0

As seen at the recent Adelaide Security seminar, here is the latest threat modelling tool from Microsoft.