How to truncate log file in SQL Server 2005

Found this nice article on how to truncate or totally eliminate log file in SQL Server 2005. I had to do this, because one of my websites' log file got up 6Gig. The procedure is not recommended by Microsoft for live databases, but I could not afford to have it take up that much space. Something had to be done. :)

Eliminate the log file completely

1. Detach the database



2. Rename the log file



3. Attach the database without the log file by highlighting the log file and click the 'Remove' button



4. Delete the log file

Source: http://www.codeproject.com/

MS SQL Server Suspect Database

Ever had your database marked as 'Suspect'? It happened to me today, and it's easily fixed by restarting SQL Server.

Blue-footed Boobies

These are birds that were spotted by Darwin on the Galapagos Islands.



Source: http://www.livescience.com/

Photo of the Day

Don't you want to be there right now? I know I do. :)



Source: http://photo.net/photodb/photo?photo_id=4920356&size=lg

Create a Transparent Image using Adobe Photoshop

I've finally learned how to create a transparent image using Adobe Photoshop. As you can see the new Dealyzer logo is now transparent. :D



Thanks to Vishah for putting it together.

Source: http://www.axialis.com/tutorials/tutorial-misc001.html

Speed Painting by Nico Di Mattia

This is really amazing! Check it out for yourself.

My Mom Cooks

This one goes out to my mom and her relentless cooking effort. Thanks to her; we're a happy and full family! :)

I will be taking pictures of our dinner and posting them here http://mymomcooks.blogspot.com/.