Pages

Wednesday, 30 July 2014

SSMS Add-in feature request

We all use SSMS, we all love SSMS, it's really good. 

I know we use it everyday and it hardly ever breaks, but Microsoft don't add new features very often.
This can be somewhat frustrating, you can buy 3rd party Add-ins, to extend the functionality, but technically these are unsupported by Microsoft. 

A while ago, I wrote a couple of SSMS Add-ins for a few missing features that really bugged me, namely; code formatting, scripting data and schema (I know you can do it, but not from a right click on a table) and a versioning Add-in (this tracked each schema change and showed it in SSMS).

I stopped working on these a while ago, but after SQLBits, I've decided to dust off the code I uploaded into CodePlex and pick up where I left off.

So I put a request for new features on twitter, I got the following requests;
1) Cats (I assume the musical)
2) Calendar with community events in it
3) Porn
4) To produce server build documentation
5) A quick way of seeing all the extended properties on a table and all its columns. And editing them!
6) Some way of indicating the IDENTITY column if there is one?
7) Something that shows the partitioning wouldn't go amiss either and the age of the stats
8) Size of the table in Kb/Mb? Same with the indexes?
9) Is it possible to see number of table reads/scans for a particular table?
10) A feature that says "Please remove this software from your computer as you clearly have not idea what you are doing!"? I would prefer something that gives electric shocks as well but I think that Amnesty International and the unions may have object to that!!

Feel free to add more features requests to the blog comments.