SSMS Tools Pack – Review
I downloaded the SSMS Tools Pack about 3 weeks ago at the urging of a co-worker. Boy I am glad I did. There are many useful tools in this collection from Mladen Prajdic.
Below are the tools that I have used the most (and LOVE)
- Text document Regions and Debug sections – This helps with very large Stored Procedures. I know this because for the passed month, I have had to wade through very large ones.
- Window Connection Coloring – This tool is awesome if you are having to constantly switch between Development, Staging and Production servers. It has already saved me several times.
- New Query Template – Nice tool to help speed up creating a new query by defaulting in items from a template.
Other useful tools included in the pack
- Query Execution History (Soft Source Control) and Current Window History.
- Search Table or Database Data.
- Uppercase/Lowercase keywords and proper case Database Object Names.
- Run one script on multiple databases.
- Copy execution plan bitmaps to clipboard.
- Search Results in Grid Mode and Execution Plans.
- Generate Insert statements for a single table, the whole database or current result sets in grids.
- Running custom scripts from Object explorer’s Context menu.
- CRUD (Create, Read, Update, Delete) stored procedure generation.
So far, I find the SSMS Tools Pack extremely useful and am happy my co-worker recommended it.
–
Until next time…
Posted on August 7, 2009, in Reviews/Recommendations, SQL Server. Bookmark the permalink. 1 Comment.
Heck yeah, he rocks. If it had autocomplete… salivating…