How can we help you today? How can we help you today?

Looking for feedback on SQL Prompt

Hi all,

I’m Adam, a Product Manager on the SQL Prompt team at Redgate. This is my first time posting here, so I wanted to quickly introduce myself and open up a conversation.

We’re currently exploring ways to improve SQL Prompt and would really value your input. Specifically, we’re interested in hearing:

  • What slows you down when writing SQL?
  • Are there any repetitive tasks you wish SQL Prompt handled better?
  • What would help you write cleaner, more consistent SQL?
  • Any features or improvements you’ve been hoping to see?

If you’ve got thoughts—big or small—we’re listening. Your feedback helps shape what we build next.

Thanks in advance,
Adam
Product Manager, SQL Prompt

Adam Atreides
2

Comments

5 comments

  • Boris

    Hi Adam!

    We have a couple of licenses for SQL Prompt because we deal with rather large and complex stored procedures and generally huge SQL files on a daily basis. One of the most-missed features for us is “named regions” as they are supported by SSMSBoost, SQL Complete, and SSMS Tools Pack. Screenshots here:

    https://www.ssmsboost.com/Features/ssms-add-in-regions
    https://docs.devart.com/sqlcomplete/writing-sql-with-code-completion/named-regions.html

    Regions should stay collapsed when opening a file, or at least make it configurable.

     

    Oh, and could you give the commands some icons, so that we can put some commands (e.g. “Select in Object Explorer”, and “Format SQL”) as tool buttons in the tool bar?

    Regards,
    Boris

    Boris
    0
  • cdbzb

    I have been having issues for years now with SQL Prompt causing SSMS to hang after connecting to more than five SQL instances (even if I disconnect a couple and then connect to a new instance).  I hesitated installing SQL Prompt in SSMS 21 because everything was finally working.  BUT - I really value some features and I finally took the plunge.  Unfortunately, I am again experiencing the issue.  I have turned off “Enable Code Analysis” as suggested in previous posts to no avail.  I would love a way to clear SQL Prompt's cache as I am pretty sure that the issue I am experiencing is a bloated cache containing all of the info scanned by SQL Prompt when I connect to an instance.

    I put this here since I think this would be a great feature to add, however, if you think I should create a separate forum post for this issue, I can do that.

    Thank you!

    cdbzb
    0
  • Tom

    The search textbox on the SQL History main/home screen is currently just a textbox shaped button that takes one to the search screen. Would you please make it a functional textbox to allow one to start one's search from there like we could back in the day?

    Thanks,
    Tom

    Tom
    0
  • George Walkey

    Hi Adam,

    for “ways to improve SQL Prompt”

    try switching from SQLLite to SQL Server Express and be more aggressive on your indexing strategy

    Every morning, I have to wait 60-120 seconds for SQL Prompt to load on either SSMS 20 or 21

     

    George Walkey
    0
  • Matt Benham

    Automatically build MERGE statements that synchronise content between two similar or identical table schemas (or a source CTE). The “WHEN MATCHED AND … THEN UPDATE SET …” is especially painful and verbose. I usually construct the SQL using Excel formula. I'm sure I can't be the only person with a use-case for merge statements to efficiently synchronise live tables from staging tables?

    Any solution would need to handle changes in nullable columns that have changed to or from null values.

    Matt Benham
    0

Add comment

Please sign in to leave a comment.