Handy and Simple tool for SSMS 2008 R2???

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Handy and Simple tool for SSMS 2008 R2???

Handy and Simple tool for SSMS 2008 R2???

Rate Topic

Display Mode

Topic Options

Author

Message

eidjazparwaz

Posted Monday, October 01, 2012 5:04 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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 (18 views, 18.96 KB)

Post #1366484

mister.magoo

Posted Monday, October 01, 2012 5:15 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:50 PM
Points: 1,308, Visits: 3,899

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

Post #1366488

eidjazparwaz

Posted Monday, October 01, 2012 7:49 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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

mister.magoo

Posted Thursday, December 06, 2012 12:58 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:50 PM
Points: 1,308, Visits: 3,899

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

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:

Post Attachments

Quick Maths.PNG (118 views, 19.62 KB)

Post #1393717

eidjazparwaz

Posted Friday, December 07, 2012 1:15 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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 Wink

.

Thanks a lot mate.

Cheers Cool

Post #1393909

mister.magoo

Posted Friday, December 07, 2012 5:06 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:50 PM
Points: 1,308, Visits: 3,899

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 Wink

.

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 Smile

Post #1394002

eidjazparwaz

Posted Friday, December 07, 2012 5:13 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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 Wink

.

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 Smile

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

eidjazparwaz

Posted Wednesday, January 23, 2013 7:12 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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

mister.magoo

Posted Wednesday, January 23, 2013 8:37 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:50 PM
Points: 1,308, Visits: 3,899

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

Post #1410626

eidjazparwaz

Posted Wednesday, January 23, 2013 8:58 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 5:27 AM
Points: 11, Visits: 69

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 »

Permissions