Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Handy and Simple tool for SSMS 2008 R2??? Expand / Collapse
Author
Message
Posted Monday, October 1, 2012 5:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 28, 2014 1:42 AM
Points: 11, Visits: 103
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.


  Post Attachments 
Microsoft Excel - Book2_2012-10-01_12-59-17.jpg (22 views, 18.96 KB)
Post #1366484
Posted Monday, October 1, 2012 5:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 5:36 PM
Points: 1,816, Visits: 5,916
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


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1366488
    Posted Monday, October 1, 2012 7:49 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Friday, November 28, 2014 1:42 AM
    Points: 11, Visits: 103
    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
    Post #1366570
    Posted Thursday, December 6, 2012 12:58 PM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 5:36 PM
    Points: 1,816, Visits: 5,916
    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 what

    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


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw



  •   Post Attachments 
    Quick Maths.PNG (167 views, 19.62 KB)
    Post #1393717
    Posted Friday, December 7, 2012 1:15 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Friday, November 28, 2014 1:42 AM
    Points: 11, Visits: 103
    Hi mister.magoo,

    I see you have been quite busy with developing. This add-in looks really () 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
    Post #1393909
    Posted Friday, December 7, 2012 5:06 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 5:36 PM
    Points: 1,816, Visits: 5,916
    eidjazparwaz (12/7/2012)
    Hi mister.magoo,

    I see you have been quite busy with developing. This add-in looks really () 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


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1394002
    Posted Friday, December 7, 2012 5:13 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Friday, November 28, 2014 1:42 AM
    Points: 11, Visits: 103
    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 () 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
    Post #1394004
    Posted Wednesday, January 23, 2013 7:12 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Friday, November 28, 2014 1:42 AM
    Points: 11, Visits: 103
    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
    Post #1410559
    Posted Wednesday, January 23, 2013 8:37 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 5:36 PM
    Points: 1,816, Visits: 5,916
    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


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1410626
    Posted Wednesday, January 23, 2013 8:58 AM
    Grasshopper

    GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

    Group: General Forum Members
    Last Login: Friday, November 28, 2014 1:42 AM
    Points: 11, Visits: 103
    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
    Post #1410647
    « Prev Topic | Next Topic »

    Add to briefcase 12»»

    Permissions Expand / Collapse