prevent exploding pc

So I went ahead and got a second stick of RAM today (I had 1x8, upgrading to 2x8). Admittedly, I did not unplug the power cable, only merely flipped the switch off. I quickly slotted the stick in, flipped the on switch, and upon pressing the power button, POOF! A loud bang and flash as the...