Awk VS Sed

What's the difference between sed and awk? I don't know, I really don't care too much, but I do care to know which one I should be using for different tasks. I do know that sed seems easier to use than awk. I may sometime get around to writing some tips, tricks and differences between the two utilities. But in the meantime, David from Carnival of Technology has a very nice article about sed and awk, which answered my immediate questions:

How do I remove all comments from a shell script? Should I use sed or awk to do global search and replace operations in a MySQL dump file? I think sed is the right choice for both of them for now.