Monday, August 27, 2007

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


Sunday, August 26, 2007

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.

Monday, August 20, 2007

Blue-footed Boobies

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


Friday, August 17, 2007

Photo of the Day

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


Tuesday, August 14, 2007

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

Dealyzer Logo

Thanks to Vishah for putting it together.


Monday, August 13, 2007

Speed Painting by Nico Di Mattia

This is really amazing! Check it out for yourself.

Friday, August 3, 2007

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