621 results found

1. Fix SQL History

   User of SQL Prompt for some years now. Tab History was a "killer feature". I often have multiple instances of SSMS open, with a number of ad-hoc queries open not worth saving. When I log back in, for years, WITHOUT FAIL, ALL my queries, from ALL instances would re-open.

   Since "upgrading" to SQL; History, I am lucky to get one or two re-open. Complete pot luck. Even searching for known keywords to get them open again is hit and miss.

   I am losing a lot of productivity due to this downgrade. I have yet to experience any benefit from the additional features of SQL History (although I am sure that might happen).

   User of SQL Prompt for some years now. Tab History was a "killer feature". I often have multiple instances of SSMS open, with a number of ad-hoc queries open not worth saving. When I log back in, for years, WITHOUT FAIL, ALL my queries, from ALL instances would re-open.

   Since "upgrading" to SQL; History, I am lucky to get one or two re-open. Complete pot luck. Even searching for known keywords to get them open again is hit and miss.

   I am losing a lot of productivity due to this downgrade. I have yet to experience any benefit from the… more

   12 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Bring Back Tab History

   Tab History NEVER should have been replaced with SQL History, a very poorly received roll-out that angered many paying customers. The fact that Red-gate felt it necessary to re-brand the thing is indication enough that it wasn't simply an update to Tab history but a replacement. That said when you do something like this in a product people are paying for it should be rolled out as something new and not something that replaces an existing beloved feature.

   Perhaps after enough updates SQL history will be usable and thus tab history unnecessary but there's no telling how many updates that will take if it's ever doable so I want to see Tab History returned and SQL History as a separate feature. As long as SQL history is not optional I may never upgrade SQL Prompt again. Perhaps it's time to check out some of your competitors products.

   Let the paying customer decide what they want to use!

   Tab History NEVER should have been replaced with SQL History, a very poorly received roll-out that angered many paying customers. The fact that Red-gate felt it necessary to re-brand the thing is indication enough that it wasn't simply an update to Tab history but a replacement. That said when you do something like this in a product people are paying for it should be rolled out as something new and not something that replaces an existing beloved feature.

   Perhaps after enough updates SQL history will be usable and thus tab history unnecessary but there's no telling how many updates that… more

   15 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. New Case When Intend option

   The new option would allow intending from alias (in alias = expression notation)

   •  

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Remember search settings in Tab History

   At present, when I search (and I hate that the search opens as a new screen), I have to click "advanced search", and select object type of "queries" (I'm really not interested in the query history, I'd rather turn it off but there's no option to do that)

   The one thing that would be most useful thought would be to remember the advanced settings between uses - or maybe allow them to be saved as a search default. This would go some way to address the poor user interface changes that have made the new SQL History much harder to use and much less useful than SQL Tab History used to be.

   At present, when I search (and I hate that the search opens as a new screen), I have to click "advanced search", and select object type of "queries" (I'm really not interested in the query history, I'd rather turn it off but there's no option to do that)

   The one thing that would be most useful thought would be to remember the advanced settings between uses - or maybe allow them to be saved as a search default. This would go some way to address the poor user interface changes that have made the new SQL History much harder to… more

   7 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. SQL history - Allow user to set custom SqlHistory.db save location

   SQL Prompt allows users to set custom directories for various files.

   It would be nice to be able to change the location of the SqlHistory.db and other files that load to localappdata.

   I would love to have this update to a folder in my oneDrive folder so it is backed up and easier to migrate between computers.

   The only way to do this now is via REGEDIT.

   5 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  User interface  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Create snippet to apply on each line in the selected text.

   I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.

   If you select some text it would be nice to format each line to a certain format.
   Like for example

   E46337E5-ECBC-41D4-A63E-A994E16BD8F7
   669F0B8E-5E1C-47CE-A799-81B47C9BC045
   65D23D56-7EB8-44AE-9158-C3D8B5684357
   AAFE4057-10B9-4AE8-BE76-C22537D29790
   4426C0B6-6216-4BFE-BE54-C1D917B593A5
   7BC5ED9E-E8C3-4618-B625-786F4B931D97
   01A37706-63FA-46E5-99EE-293FF290B34D
   94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
   2C801ADE-995A-4158-9D0A-7DA03911D093
   425BAAC6-6A0B-419C-B393-79B21A628538

   turn into

   ('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
   ('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
   ('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
   ('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
   ('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
   ('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
   ('01A37706-63FA-46E5-99EE-293FF290B34D'),
   ('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
   ('2C801ADE-995A-4158-9D0A-7DA03911D093'),
   ('425BAAC6-6A0B-419C-B393-79B21A628538')

   OR even better

   prepend

   SELECT t.x FROM (VALUES

   and append

   ) t(x)

   I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with the help of block selection (that unfortunately doesn't function like it does in Visual Studio)

   The thing is you guys rock and you achieved it for the quotes and commas. So...

   I would be grateful.

   David

   I really love the add (quotes and) commas feature in SQL Prompt. Unfortunately we cannot produce a snippet similar to those.

   If you select some text it would be nice to format each line to a certain format.
   Like for example

   E46337E5-ECBC-41D4-A63E-A994E16BD8F7
   669F0B8E-5E1C-47CE-A799-81B47C9BC045
   65D23D56-7EB8-44AE-9158-C3D8B5684357
   AAFE4057-10B9-4AE8-BE76-C22537D29790
   4426C0B6-6216-4BFE-BE54-C1D917B593A5
   7BC5ED9E-E8C3-4618-B625-786F4B931D97
   01A37706-63FA-46E5-99EE-293FF290B34D
   94CAB432-EA1C-4972-8CD6-3C8B9E1A096B
   2C801ADE-995A-4158-9D0A-7DA03911D093
   425BAAC6-6A0B-419C-B393-79B21A628538

   turn into

   ('E46337E5-ECBC-41D4-A63E-A994E16BD8F7'),
   ('669F0B8E-5E1C-47CE-A799-81B47C9BC045'),
   ('65D23D56-7EB8-44AE-9158-C3D8B5684357'),
   ('AAFE4057-10B9-4AE8-BE76-C22537D29790'),
   ('4426C0B6-6216-4BFE-BE54-C1D917B593A5'),
   ('7BC5ED9E-E8C3-4618-B625-786F4B931D97'),
   ('01A37706-63FA-46E5-99EE-293FF290B34D'),
   ('94CAB432-EA1C-4972-8CD6-3C8B9E1A096B'),
   ('2C801ADE-995A-4158-9D0A-7DA03911D093'),
   ('425BAAC6-6A0B-419C-B393-79B21A628538')

   OR even better

   prepend

   SELECT t.x FROM (VALUES

   and append

   ) t(x)

   I often use this format to look up data in the database. I know I can achieve this with Excel and consorts. Or even with… more

   4 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

7. Automatic updates for SQL Prompt without the need for administrator privileges

   Currently users have to install SQL Prompt updates manually and this requires administrator privileges which is not ideal in a workplace setting. I was wondering if this could be changed so that SQL Prompt updates itself without the need for manual install and administrator privileges.

   Thank you in advance for your help.

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. SQL history - Reintroduce lost features

   SQL history. Recently this has become more indepth with greater search and history detail available. However it has lost some features which I found to be invaluable and which now make SQL history less useful to me.

   Find Starred items doesn't work as well now. It uses the advanced search which does not actually show if items are starred. Please correct that.

   Also there is now no ability to sort items found (in either normal or search view) by name / date etc.

   Can these features be re-implemented please.

   15 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   under review  ·  3 comments  ·  Tab history  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. AI

   AI suggestions.

   I'm not part of your AI program waiting list. However here what I suggest.

   Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to the users.

   Things I should ask it to do and have it do it.

   Have it build a local vector db / learn the database based on SQL History.

   Do query rewriting.
   Example: Tell it don't use case( and use convert( or vise versa and it will rewrite the syntax.

   Describe a SQL function/SP and have it write that code.

   Have it analyzed Query execution plan and make suggestions to the SQL query to improve its performance, like suggesting indexes, or a rewrite of the query to improve performance.

   Document my query / or document my database.

   Explain a data problem and have it try to figure it out. Example:
   Q: On Order 123, why is that order being reported Cancelled.
   
   A: You have QueryOrders you have a case statement ISCancelled if the Cancelled date is not null it returned as Cancelled.
    
   Q; What job will execute this stored procedure?
   A: Job RunSalesOrder step 4 will call this stored procedure.

   Translate SQL lang to another SQL lang.

   AI suggestions.

   I'm not part of your AI program waiting list. However here what I suggest.

   Do not make the AI part of your program an only cloud-based solution. There are plenty of opensource code models free for commercial use that can be ran locally on a PC. These models can also run under CPU but will up the memory to enable this feature requirements for AI on client side only. It's too dangerous for Redgate to store this information on the cloud even with a solid EULA, and laws are subject to change. Please offload this burden back to… more

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Platform Support  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

10. Enable block comments in SQL

    SQL Prompt and SSMS do not have the option to create/remove block comments. This is a serious problem.

    We SQL Prompt users would love the option to add/remove block comments in SQL, between the marks /* and */, because they sometimes serve very different purposes.

    Inline comment options (Ctrl + K, Ctrl + C or Ctrl + K, Ctrl + U) are helpful, but they don't always do exactly what we need. Sometimes they can break things. See below.

    /*
    Sometimes we need block comments that cover multiple lines.
    Like this.
    /
    / Or comments where each line begins and ends with the markers. /
    / Like this. */

    Sometimes inline comments, beginning with "- -", get inadvertently uncommented, and it can have major consequences. For one, it can be VERY hard to find the old textual comments. More importantly, lines of SQL code get uncommented, and they can alter or delete an entire table's contents.

    -- A line of test code might feature a truncation from an earlier version
    -- truncate table_name;

    Can you please add a button/hot key combination that will add/remove comments that begin with /* and end with */?

    NOTE:
    This feature is available in other IDEs like Visual Studio and VS Code:
    - Windows: Shift + Alt + A
    - Mac: Shift + Option + A

    SQL Prompt and SSMS do not have the option to create/remove block comments. This is a serious problem.

    We SQL Prompt users would love the option to add/remove block comments in SQL, between the marks /* and */, because they sometimes serve very different purposes.

    Inline comment options (Ctrl + K, Ctrl + C or Ctrl + K, Ctrl + U) are helpful, but they don't always do exactly what we need. Sometimes they can break things. See below.

    /*
    Sometimes we need block comments that cover multiple lines.
    Like this.
    /
    / Or comments where each line begins and… more

    5 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    2 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

11. SQL History SORT BY option, as in DATE DESC

    SQL History sorts files by modified date ASCENDING. Its needs to be DATE DESCENDING. Need options to sort by name or date, ASC or DESC. Like how TAB HISTORY used to.

    8 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Tab history  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    under review  ·  AdminTim Dalton (Product Manager, Redgate) responded

    
    

12. Open SQL History on startup / keep SQL History docked

    I prefer opening SSMS with no tabs and use SQL History to navigate tab history. It would be great to have an option to open SQL History on startup and/or if SQL History is docked then redock SQL History on startup

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

13. Auto-Correct TOP to include Parenthesis

    Add an Enable checkbox in the Style Sheet | Global | Parenthesis settings.

    When SQL Prompt encounters the 'old style' usage of TOP, without parenthesis, automatically enclose the apparent 'what' in parenthesis.

    6 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

14. Copy as IN clause" on a resultset - put results all on one line

    With SQL Prompt, and selecting "Copy as IN clause" on a resultset, is it possible to format the result as all one line, like:

    IN (1,2,3,4,5,6)

    instead of what it does currently:

    IN (

    1,

    2,

    3,

    4,

    5,

    6) ?

    Having it all on one line makes a statement easier to read, when there are a lot of items in the list.

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

15. Add Trim() to LTRIM(RTRIM()) toggle

    For those of us who have to move between current and older versions of SQL Server, provide a tool to toggle all TRIMS in a script to LTRIM(RTRIMS()) and vice versa to make it easier to adapt scripts when moving between server version.

    Thanks,
    Mad Character Trimmer

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

16. Version Stamping

    Our dev group versions our styles. A small change between style versions can cause numerous changes in a single file making peer reviews more difficult than they need to be.

    My suggestion is to add an Format > Styles > Actions option to add style stamp. Implementation would be adding a comment with a style/version stamp at the top of the file when a format is applied. If the comment exists prior to formatting, that style will be used by SQL Prompt regardless of selected style. If the style/version is not found, the selected style is used. To change which style to apply, dev simply removes the comment before formatting.

    Examples:

    Formatted with supplied Default
    /Formatted by SQL Prompt using Default/

    Formatted with custom, versioned style
    /Formatted by SQL Prompt using My Style 1.1/

    Our dev group versions our styles. A small change between style versions can cause numerous changes in a single file making peer reviews more difficult than they need to be.

    My suggestion is to add an Format > Styles > Actions option to add style stamp. Implementation would be adding a comment with a style/version stamp at the top of the file when a format is applied. If the comment exists prior to formatting, that style will be used by SQL Prompt regardless of selected style. If the style/version is not found, the selected style is used. To change which… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Format SQL  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

17. SQL History

    'History for SQL Queryxxx' pane - there are too many versions. I don't need a version for every minor change. How about adding an option for how often to save versions?

    10 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

18. Disable update and new notifications

    It would be great if you would introduce a new setting where we can turn of update- and other notifications (like "SQL 2008R2 not supported") warnings.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  User interface  ·  Edit…  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

19. Computed Column Update process

    Occasionally I must edit the definition of a computed column. As editing a computed column is not allowed from SQL, would be nice to generate a script that would facilitate this update, similar to the rename script. (Ie, drops indexes, drops the field, recreates the field, and recreates the indexes.)

    Obviously this is similar to the functionality of the Smart Rename, except doesnt' have to edit Views and Sprocs, so hopefully most of the logic could quickly copy over from there!

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Script object as alter  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

20. Shortcut Keys and/or Button Bar Buttons for Command Tab Options Like Add Commas and Add Quotes and Commas

    When you open the command pallet the tools under the Commands tab like 'Add Commas' and 'Add Quotes and Commas' are extremely useful. It would be a tremendous time saver to not have to get to them via the menu and simply be able to assign them to Shortcut Keys and/or Toolbar buttons. There are quite a few options that can be assigned to buttons, but not these. Please consider adding this feature.

    Thanks,
    CommaChallenged

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close