Tuesday, February 16, 2010

New tool I'm using - SSMS Tools Pack

We do a lot of SQL Server programming where I work. I'm using SQL Server Management Studio 2008, which is nice, but I just made it much nicer by installing Mladen Prajdic’s SSMS Tools Pack (http://ssmstoolspack.com/). The features I've discovered so far are:
  • color coding the editor by connection (so you have a visual cue that you're connected to production versus QA versus your development DB)
  • auto-formatting
  • snippets
  • New Query templates (so you always start with a Begin Tran)
I like this quite a bit.