Handy and Simple tool for SSMS 2008 R2???

Question

Post reply

Handy and Simple tool for SSMS 2008 R2???

eidjazparwaz

SSC-Addicted

Points: 487
More actions
October 1, 2012 at 5:04 am

#265109

Hello,
I was wondering why SSMS does not have the standard builtIn plugin Quick Math (for example: sum, avg, max, min). I have been searching on google but couldn't found any tool which will add this possibility to SSMS.
Do you guys know any tool or tips how to added such a extension?
Br, Eidjaz
See my attach for example.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

Yes, I agree - I might look into this, I am writing an addin at the moment and that would be great.

I don't know if it is possible, but I suspect it will be.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

eidjazparwaz SSC-Addicted Points: 487 More actions · Answer 2

Hi Mister Maggo,

Thanks for your fast replay. so atm you are writing an addIn? in Which language you gonna develop it??

Best regards,

Eidjaz

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

eidjazparwaz (10/1/2012)
Hi Mister Maggo,
Thanks for your fast replay. so atm you are writing an addIn? in Which language you gonna develop it??
Best regards,
Eidjaz

Hi there, sorry for the long delay, I guess I missed your follow-up.

I am writing it in (shhh! don't tell) vb.net - wait :w00t: what :hehe:

I know, it's not cool, it's not the "programmer's language", but hey, it's what I know and it works well for me.

Things are going well and I have been using the addin myself for a couple of months now.

So far, I have implemented the following:

1. Query history - stored in a local database, with search facility (I have about 3-4 years of history in there - imported from my SSMSToolsPack history - and it takes a second or two to search through everything)

2. Template query text - for new query windows, insert template code and position cursor.

3. Grid tweaks

a) Freeze panes (like Excel) for those really wide result sets.

b) Quick Maths (like Excel) show total, average, max, min, count for selected cells (including complex selections)

c) Alternate row colouring to aid viewing. (like old dot matrix fanfold)

d) Script results grid as CREATE TABLE with correct data types - makes it easier when you have created your select statement and want to then create a table to insert the results into, without using SELECT .... INTO.

** all these work for multiple result sets, of course. **

Features to come, if I can :

1. Dynamic zoom (font size) on the grid. (definitely possible, but will it be useful/look right?)

2. Save queries to disk (for synchronisation across devices, where they cannot access the same database) (can do, just haven't yet)

3. Results archiving - needs a lot of thought, although definitely possible, it would use up a lot of disk space and cause security issues, so maybe...

4. Better code folding - the standard region handling in 2012 is terrible and I can improve it, but it's low priority.

5. Anything else that I feel like adding.

Compatibility :

So annoyed, I can get my 2008 Addin to work on 2012 except for one tiny little part, so I have to have two versions...BAH!

Anyway, it works on 2008 and 2012, not tested on 2005 because I never use it.

I will probably ask if anyone wants to test it out soon, but I need to test it myself for a bit longer first because I don't want to spend time supporting it.

I would imagine if I do release it, it will be free but closed source in case I later decide to charge, but I like the free model, so I can say 99% sure that there would always be a free version for those that can't afford to pay.

Sample screenshot:

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

eidjazparwaz SSC-Addicted Points: 487 More actions · Answer 4

Hi mister.magoo,

I see you have been quite busy with developing. This add-in looks really (:w00t:) nice and really handy. If you need some volunteers to test this add-in i dont mind to do that.

Let me know if you want me to test it for you ;-).

Thanks a lot mate.

Cheers 😎

mister.magoo SSC-Forever Points: 47068 More actions · Answer 5

eidjazparwaz (12/7/2012)
Hi mister.magoo,
I see you have been quite busy with developing. This add-in looks really (:w00t:) nice and really handy. If you need some volunteers to test this add-in i dont mind to do that.
Let me know if you want me to test it for you ;-).
Thanks a lot mate.
Cheers 😎

Thanks for the offer, as soon as I feel it is ready for user testing, I will message you 🙂

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

eidjazparwaz SSC-Addicted Points: 487 More actions · Answer 6

mister.magoo (12/7/2012)
eidjazparwaz (12/7/2012)
Hi mister.magoo,
I see you have been quite busy with developing. This add-in looks really (:w00t:) nice and really handy. If you need some volunteers to test this add-in i dont mind to do that.
Let me know if you want me to test it for you ;-).
Thanks a lot mate.
Cheers 😎
Thanks for the offer, as soon as I feel it is ready for user testing, I will message you 🙂

No problem, you thanks for making such a nice SSMS solution. I will hear it when it's ready to be tested.

Bye

eidjazparwaz SSC-Addicted Points: 487 More actions · Answer 7

Hey Mister Maggoo,

How is the developing of the new ssms grid result? cant wait to test it.. let me know when it's ready ;).

Ty

Eidjaz

mister.magoo SSC-Forever Points: 47068 More actions · Answer 8

eidjazparwaz (1/23/2013)
Hey Mister Maggoo,
How is the developing of the new ssms grid result? cant wait to test it.. let me know when it's ready ;).
Ty
Eidjaz

Hi Eidjaz,

I have not done much over the holidays, been ill a lot, other projects on the go, etc...

However, I have made a bit of an effort this week to get it into a more professional state (the settings page was awful, but functional for example).

I still need to build an installer for it, but as soon as that is done I will message you for some beta testing.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

eidjazparwaz SSC-Addicted Points: 487 More actions · Answer 9

Hai Mister Maggo,

Not good te hear that you been ill.. hope everything is fine now. No problem man let me know when you think it's ready for test.

BR,

Eidjaz

sqlhuntingdog SSC Veteran Points: 269 More actions · Answer 10

Hi Guys,

talking about plugins I have developed one - quick search for SSMS 2008 R2.

Let me know your thoughts..

please use free productivity tool for SSMS - SQL Hunting Dog [/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 11

I only use SSMS 2012 - do you have a build for that?

Do you have any screen shots or description of what it does?

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

sqlhuntingdog SSC Veteran Points: 269 More actions · Answer 12

It will work with SQL2012 Management Studio as well as with 2008 (R2).

Basically it adds a new window with easy navigation - you type a couple of letter and it shows you all matching tables, stored procedures.

You can then do usual actions on them (select data, see stored procedure body etc). The main idea was to replace Object Explorer for most of the operations.

There is a article with screenshots where I have explained why it is better than standard Object Explorer:

and here is a quick user manual:

this is the screenshot:

another one - views:

please use free productivity tool for SSMS - SQL Hunting Dog [/url]