Found an interesting post on how to develop an SSMS add-in.