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/.

Facebook is Down

This is the first time I have seen the Facebook website being taken down for upgrade. Pretty cool, isn't it? :)

BT's Birthday Dinner and a Movie

Happy Birthday, Em Nho! Dinner was at Bistro 123 in Tysons Corners. Transformers afterwards. Highly recommend everyone to go see that movie.


HA & BT


Best Angus Beef Burger Ever!


BT & Her Imaginary Car :)

Web Trends 2007

Saw this interesting map of Web trends 2007 on TechCrunch.com. Wondering where my future start-up will fit in? :)



Sources:
TechCrunch.com
InformationArchitects.jp

Mom's Office Visit

Latest AJAX Project

Group effort really paid off for this project. It helped me learn a lot about AJAX, ASP.NET 2.0, and AJAX Control Toolkit.

BT's VCU Acceptance Party

July 4th Celebration

Thanks to An and Nelson for hosting. We had a good time, and the fireworks were awesome.

New Genesant Office in Tyson Corners

Introducing Digg Clone for Vietnamese Websites

The iPhone Is Out

My Laptop Is Alive and Kicking

Had to replace the video card costing $145. I'm so happy it finally works again. :)


Inspiron E1505


The Damaged Video Card

I Want To Be a Linux User

Probably not, but this is pretty funny. :)



Source: http://xkcd.com/c272.html

What is MizPee?

It's a site that helps you find nearby restrooms. Weirdest idea for a site that I have heard of. I can see it being useful in countries like Vietnam and nothing more. Will probably fail sometime soon. The site is being covered by Techcrunch and is located here.

Weekend in Richmond and Virginia Beach

I had a great time this past weekend. Thanks Anh Hai and Chi Huong! :)


Virginia Beach


Bo Cuon La Lot