Here's a good write-up on the difference between postgres and MS SQL.

http://www.pg-versus-ms.com/

I've been collecting links from this thread for my own personal learning so thought I'd throw in the only one I came here with.