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.

Sunday, 27 July 2014

Recharging my SQL Batteries

I went to SQLBits ( the biggest SQL Server Conference in Europe) last week and came back with two things, 1) a sore knee and 2) my SQL Batteries being recharged. (Its just under 10 weeks since I broke my leg)

Last year I chaired SQL Relay, we (the SQL Relay committee) put on 10 events up and down the country.  If you think it sounds like a lot of work, it was!! But we pulled it off together.  I am massively proud of everyone involved, I can’t remember the numbers, but we had over 1000 attendees - without the helpers, sponsors and attendees we would not have pulled it off.

But its was really draining…

So now, I'm feeling recharged, refreshed and ready to go...  I've got a number of things planned, so watch this space..