SQL Server tip
Just a quick tip for when developing with SQL Server.
When doing a lot of updates in SQL the transaction log might grow quite large clogging up the disk and slowing things down. An easy and quick way to cleanup is to use:
backup log <<Database name>> with truncate_only
go
dbcc shrinkdatabase ( <<Database name>> )
go
Use the sp_databases stored procedure to see which database is getting big.
Warning: Keep in mind that the truncate_only option just dumps the transaction log so you do not want to do this on a production machine! But on a development machine where a database is just a test item it is a quick way to retrieve some disk space.
Enjoy!