Is being sore after workout an indication of an effective workout?

Soreness is caused by microscopic tears in the muscles. When you keep getting sore, your body finds it more efficient to build over the tears rather than just repairing them. The result is muscle growth. The key to progressing in your workouts is to switch techniques/routines at least every 4 weeks. Some people switch sooner, when they are no longer getting sore.