I recently was on vacation and was reminded how much I like Google's Picasa to manage my digital photos. Each night as I returned from my activities, I inserted my memory card into my laptop, launched Picasa, and had it load my new photos into a folder unique for that day. Occasionally I took a few additional sunset photos, and common to camera memory cards, when loading I ended up with duplicate file names. Picasa handles this for me by automatically renaming the new files as they were saved to my laptop.
Once the photos were on my laptop, it was very easy to take care of basic photo editing -- perfect for most of us non-Photoshop experts. For example, removing red-eye is simple; I can also sharpen photos; and of course rotation is a single click. Once my edits are complete, Picasa will save my original, so that I can always go back to it later.
Once I finished my edits, I viewed all the photos from the day using the slide show feature. And when I was happy with what I saw, it was a simple click and login (using my Gmail and Blogger account) to post my pictures on the web for viewing by friends and family.
That just scratched the surface of the power of Picasa. Even if you use expert photo editing software such as Photoshop, Picasa is a no-brainer for managing all your photos. If you haven't tried Picasa, I highly encourage you to give it a try.