SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Handy and Simple tool for SSMS 2008 R2???


Handy and Simple tool for SSMS 2008 R2???

Author
Message
eidjazparwaz
eidjazparwaz
SSC Rookie
SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

Group: General Forum Members
Points: 39 Visits: 104
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.
Attachments
mister.magoo
mister.magoo
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4264 Visits: 7865
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);




  • 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

  • eidjazparwaz
    eidjazparwaz
    SSC Rookie
    SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

    Group: General Forum Members
    Points: 39 Visits: 104
    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
    mister.magoo
    SSCarpal Tunnel
    SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

    Group: General Forum Members
    Points: 4264 Visits: 7865
    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);




  • 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

  • Attachments
    Quick Maths.PNG (176 views, 19.00 KB)
    eidjazparwaz
    eidjazparwaz
    SSC Rookie
    SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

    Group: General Forum Members
    Points: 39 Visits: 104
    Hi mister.magoo,

    I see you have been quite busy with developing. This add-in looks really (:w00tSmile 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 Cool
    mister.magoo
    mister.magoo
    SSCarpal Tunnel
    SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

    Group: General Forum Members
    Points: 4264 Visits: 7865
    eidjazparwaz (12/7/2012)
    Hi mister.magoo,

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


    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);




  • 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

  • eidjazparwaz
    eidjazparwaz
    SSC Rookie
    SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

    Group: General Forum Members
    Points: 39 Visits: 104
    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 (:w00tSmile 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 Cool


    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
    eidjazparwaz
    SSC Rookie
    SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

    Group: General Forum Members
    Points: 39 Visits: 104
    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 Wink.

    Ty

    Eidjaz
    mister.magoo
    mister.magoo
    SSCarpal Tunnel
    SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

    Group: General Forum Members
    Points: 4264 Visits: 7865
    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 Wink.

    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


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




  • 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

  • eidjazparwaz
    eidjazparwaz
    SSC Rookie
    SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)SSC Rookie (39 reputation)

    Group: General Forum Members
    Points: 39 Visits: 104
    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
    Go


    Permissions

    You can't post new topics.
    You can't post topic replies.
    You can't post new polls.
    You can't post replies to polls.
    You can't edit your own topics.
    You can't delete your own topics.
    You can't edit other topics.
    You can't delete other topics.
    You can't edit your own posts.
    You can't edit other posts.
    You can't delete your own posts.
    You can't delete other posts.
    You can't post events.
    You can't edit your own events.
    You can't edit other events.
    You can't delete your own events.
    You can't delete other events.
    You can't send private messages.
    You can't send emails.
    You can read topics.
    You can't vote in polls.
    You can't upload attachments.
    You can download attachments.
    You can't post HTML code.
    You can't edit HTML code.
    You can't post IFCode.
    You can't post JavaScript.
    You can post emoticons.
    You can't post or upload images.

    Select a forum

































































































































































    SQLServerCentral


    Search