SSMS Query Logging

  • ssms-man (10/9/2012)


    Phil Parkin (10/9/2012)


    ssms-man (10/9/2012)


    Phil Parkin (10/8/2012)


    I've downloaded and installed SSMS Boost. Some interesting features and some usability issues too (eg Script Object as CREATE/ALTER fails with 'No suitable objects found at cursor position' unless you are in the same database context as the object which you are trying to script - even if fully qualified - puzzled me for a while). Promising though - keep it up.

    Right, this is "known" feature 😉 It is in "to fix" list for next release.

    My own development request - please add support for collapsible regions like in C#. This has been removed from SSMS Tools latest version because regions are apparently 'supported' in SSMS 2012. But they're not really, IMO.

    Why do you write,that they are not supported in SSMS2012 ? I can see them there. Or don't you like the way they are implemented ?

    OK - first of all my disclaimer: we are in the process of upgrading to SSMS 2012, so I have only been using it for the last week. Maybe I have missed something 🙂

    But it seems that SSMS 2012 does not give you control over your regions, rather it adopts an 'I know best' attitude when determining what the regions should be.

    With SSMS tools, pre 2012, I was able to structure long and complex scripts into collapsible sections. Simply by pressing CTRL-K, CTRL-J, the regions would collapse, leaving me with a screen of headings which made navigation easy. See attached image for an example. Those regions contains many lines of code which would not be grouped in SSMS 2012.

    I know that there is the 'hide' function in SSMS 2012, which works the way I want, but the hidden areas are not persisted between editing sessions.

    Ok, I understand what you want and will add to "to investigate" list. We did not re-use regions till now, so we'll need some time to invest before we find approriate interfaces of SQL Editor control.

    <by the way - I just have updated 2.6 version once again, with some small fixes/additions reported by users since yesterday>

    Good man. If you won't be looking at this for a while, can I suggest that you contact me when you do get round to it? I may just have written something myself by then which you might be able to use.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Ok, I understand what you want and will add to "to investigate" list. We did not re-use regions till now, so we'll need some time to invest before we find approriate interfaces of SQL Editor control.

    <by the way - I just have updated 2.6 version once again, with some small fixes/additions reported by users since yesterday>

    Good man. If you won't be looking at this for a while, can I suggest that you contact me when you do get round to it? I may just have written something myself by then which you might be able to use.

    Ok, thank you ! I will do.

    Just in case: I have created a sample project for SSMS 2012 add-in. It has some minor theory and a downloadable project:

    http://www.ssmsboost.com/create-own-ssms-2012-add-in-sample-code-with-download

    It might save you some hours 🙂

  • ssms-man (10/9/2012)


    Ok, I understand what you want and will add to "to investigate" list. We did not re-use regions till now, so we'll need some time to invest before we find approriate interfaces of SQL Editor control.

    <by the way - I just have updated 2.6 version once again, with some small fixes/additions reported by users since yesterday>

    Good man. If you won't be looking at this for a while, can I suggest that you contact me when you do get round to it? I may just have written something myself by then which you might be able to use.

    Ok, thank you ! I will do.

    Just in case: I have created a sample project for SSMS 2012 add-in. It has some minor theory and a downloadable project:

    http://www.ssmsboost.com/create-own-ssms-2012-add-in-sample-code-with-download

    It might save you some hours 🙂

    Fantastic - I'll take a look at that.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • Just an update:

    SSMSBoost v2.7 was released yesterday. We have added "Find in Grid" functionality. Statement logging and Auto-sessions are still on the way. We need some more time to make good UI, so we have decided to make intermediate release. Next release planned to end of January.

  • ssms-man (12/4/2012)


    Just an update:

    SSMSBoost v2.7 was released yesterday. We have added "Find in Grid" functionality. Statement logging and Auto-sessions are still on the way. We need some more time to make good UI, so we have decided to make intermediate release. Next release planned to end of January.

    I would really be interested in the statement logging as well. im downloading as i type.


    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • ....some months later.....

    SSMSBoost v 2.9 released today.

    Added:

    -Executed Statements logging

    -Script Editor history

    -Recent Tabs (including connection)

    have fun !

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply