Friday, 27 August 2010

SQL Server utilities: SSMS Tools Pack


Working with SQL  Server sometimes is really boring: you need to write a lot of stuff and - as an almost-without-memory person as I am - remember 'how were those stored procedures done'. I know very expert people who use a simple list of cleverly named txt  file, where they store all the knowledge. So when a specific function/procedure is needed, they look into that knowledge base, copy and paste. That's handy, and - as humans - quite helpful.

If you use Microsoft SLQ Server Management Studio to do your database development and maintenance, you might find the SSMS Tools Pack very useful. I've used the tool for some time and I really don't think I can do without it now.

The features include:

  •     SQL Snippets
  •     Window Connection Coloring
  •     Query Execution History and Current Window History
  •     Format SQL
  •     Search Table, View or Database Data
  •     Run one script on multiple databases
  •     Copy execution plan bitmaps to clipboard or file
  •     Search Results in Grid Mode
  •     Generate Insert statements from resultsets, tables or database
  •     Regions and Debug sections
  •     Running custom scripts from Object Explorer
  •     CRUD stored procedure generation
  •     New query template
  •     General options

As you can see it's a bunch of very handy and helpful stuff. Once you start using it, it will be difficult to even think to do without it.

0 thoughts:

Post a Comment

Comments are moderated. I apologize if I don't publish comments immediately.

However, I do answer to all the comments.