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.

Code profiling, memory profiling - ANTS Profiler

Wednesday, 8 March 2006

I’d like to see a comparison of the ANTS profiler versus the inbuilt performance analysis tool in VSTS

For that matter, it would also be interesting to compare it with Rational Quantify too. I’ve got that, but have not found it the most intuitive tool to use, and am also wondering about IBM/Rational’s commitment to .NET.