Code analysis and flowcharting utilities

Sunday, 19 March 2006

Might have to give these a try out on some of my code. If the diagrams get too complicated, then it's probably a good sign that the code could use a re-write!

SQL Server 2005 SP1 March CTP

Friday, 17 March 2006

SQL Server 2005 has only been out for a few months and they're already working on Service Pack 1!

The list of fixes will eventually be posted to KB article 913090.

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

Wednesday, 15 March 2006

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

Tuesday, 14 March 2006

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

Friday, 10 March 2006

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