My favorite SSMS add-in….SSMSBoost

Sql Server Management Studio is very robust and can do many things, but like any other product cannot do everything.  Luckily there are add-ins available that fill in some of the gaps.  My favorite and one I use every single day is SSMSBoost:

http://www.ssmsboost.com


It has a FREE Community Edition which does everything the paid version does, but you need to just download the newest version every 120 days and install over the current version.  It does not overwrite any of your settings, so this 2 minute process is definitely worth it.

I could write 20 articles about the features, but below are three I use every day.

 

Find in Editor History

After using TOAD for Oracle for almost 10 years, I really appreciated the SQL Recall feature it had. If you wrote a onetime query for a user and did not save it, and then the next day they just wanted one tweak, you would have to recreate the query.  Having the recall, you could look back and see all of queries you ran and bring it back up and make modifications.  When I switched over to Sql Server, SSMS did not have this functionality, so I searched for something free that would do this. I finally found SSMSBoost which had this feature and provided all kinds of options for how it behaves.

sqlhistory_options

 

 

 

 

 

 

For example (above), I just have it save the query only if it actually executes.  If you have a syntax error, it will not save the query.

Below is how you would search for a query:

sqlhistory_history

Click the History button -> Find in Editor History

 

Type in some distinguishing text to search for that you remember from the query and pick what time frame you want to search back from.

sqlhistory_find

Click Find.

 

sqlhistory_find2

 

Double click the item that shows up and it will open up the query in SSMS. You just saved yourself a bunch of time from having to rewrite a query.

 

sqlhistory_results

 

 

Exporting Results to Excel

Many times an end user will ask for data out of the database and wants it in Excel. You can right click and save results as or copy out the values by Selecting all and copying them out.  If you use SSMSBoost, this is more efficient, because it keeps the datatype that the data is when it comes over to Excel.  This means if you have leading zero’s or other special characters, they will not get dropped off or changed when the file is opened in Excel or if you save the file as a csv file, it will not split up the field to another column due to it having a comma in it.

Just right click and choose: Script grid data

export1

That brings up the following box. Select the Excel template, and then click Start Scripting, after it is done, click the link below output files.

export2

 

This brings up your data, all nice and formatted in Excel.  Notice the leading zero is still present and the delivery location looks correct.

export3

 

Below, this is how it looks when you just copy it and past the results out of the grid or saving the results grid.  Notice the gibberish data and the leading zero is droppedThis is incorrect and you could provide invalid data.  You never have to do this again, if you use the method above.

export4

 

Auto Replacements

The last feature I use every day is Auto Replacements, otherwise known as spellcheck. If you spell WHERE incorrectly as often I do, you will love this feature.  You can add any words that you misspell or you can even use it for code completion (see second screenshot)

auto1

 

Below is a time saving auto replacement feature: If you type in sel and then press space, it changes it to: select * from

You can also create your own!

 

auto2

 

This has been a summary of some very useful features of SSMSBoost that I use every day and would be very sad if they no longer existed. I will more than likely do another post on some other cool features that I use with it since there are so many.

No, I am not a spokesman for this add-in, but it just works so well, I need to tell people.

Please let me know of any FREE tools that you use that are time saving or you really like.

 

Thanks for reading!

2 thoughts on “My favorite SSMS add-in….SSMSBoost”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s