Code analysis and flowcharting utilities

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!

• Code Visual to Flowchart
• Project Analyzer v8 reviews & documents VB code
• Visustin v3 Flow chart generator
• CLR Profiler for the .NET Framework 2.0

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.