SQL Server 2005 SP1 March CTP

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

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).