16 results found

1. VSCode integration.

   I've used SQL Prompt for 20 years. I would LOVE VSCode integration.

   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  ·  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

2. Sql prompt support for Dedicated SQL pool

   Add support for Dedicated SQL pool on Azure Synapse.

   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  ·  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

3. Reprompt for authentication on MFA for Azure SQL Databases for expired tokens

   When you use the interactive sign in with AD option with a SQL database, it's not very stable in it's connection. I suspect it's either not supporting the refresh tokens (if it has them) or hasn't got the right detection for an expired token.

   When authentication fails in this mode, it gives up silently and functionality starts to turn off as it can't connect to the database - see attached log.

   I have to close SSMS every 3 hours or so, which forces SQL prompt to re-authenticate and get a new token. Turning on/off suggestions does not trigger a reauthentication.

   • 

   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  ·  Platform Support  ·  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

4. Add support for Fabric warehouses and lake houses

   Add support basic intellisense support for Fabric warehouses and lake houses.

   14 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  ·  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

5. 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

   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  ·  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

6. Support for windows certificate store

   Currently, SQL prompt doesn't support the windows certificate store like most applications do. The only way to work around that currently is to simply trust all certificates which is inconvenient (having to set this across potentially hundreds of server connections) and a security gap.

   SQL prompt should either provide an option to leverage the certificates. Currently, if a blanket trust is not provided, SSMS and SQL in general will work fine, but SQL prompt will cease to function, since the application (visual studio, SSMS) will connect correctly, but SQL prompt will not.

   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  ·  Platform Support  ·  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

7. Add "Clean install" option during installation

   Add "Clean install" checkbox with appropriate warnings and option to back up styles and tab history where the user can specify and/or change the suggested backup location by default. Offer an easy option (inside menu?) to restore from the backup once installed. Take a look at Visual Studio editor options can be exported (backed up to a file) and subsequently restored later.

   Also, take a look at nVidia, AMD Radeon (formerly ATI) and perhaps Intel network card driver installers as an example for "clean install".

   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  ·  Platform Support  ·  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

8. Generate C#/VB.NET class

   It would be nice to have the ability to right-click on a table or stored procedure and generate a C# or VB.NET class from the table structure or stored procedure results that could be used in a development solution.

   • 

   • 

   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  ·  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

9. Full support for Azure SQL Managed Instance in SQL Prompt

   SQL Prompt should fully support Azure SQL Managed Instances. This includes offering suggestions for all objects (such as system functions, tables, views, etc) which are usable in Managed Instances. For example, CURRENTTIMEZONE and CURRENTTIMEZONE_ID (which were recently implemented in SQL Prompt, but only for Azure SQL Database). All other functions I've tried seem to be working fine, but it would be nice to know that Azure SQL Managed Instance is officially supported by SQL Prompt.

   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

   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. Support for MS Dataverse / CDS

    Add support so SQL Prompt will work in SSMS when connected to MS Dataverse / CDS (Common Data Service - Dynamics really).

    Right now, it fails since the (meta)data exposed probably isn't quite as complete as on a "full-scale" SQL Server database

    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

    3 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

11. Visual Studio Preview Support

    Please add support for Visual Studio Preview versions. We frequently work in those and SQL Prompt Pro specifically is not available.

    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

    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

12. Support SSDT for SQL Prompt

    Create Install Package for installing SQL Prompt in SSDT. SSDT is a VS shell, so Prompt should be easily incorporated.

    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  ·  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

13. Schema Folders

    Please introduce Schema-Folders in SQL-Server Object Explorer
    as shown in
    https://github.com/nicholas-ross/SSMS-Schema-Folders

    Or make SQL-Prompt working together with
    https://github.com/nicholas-ross/SSMS-Schema-Folders.

    The Features "Show in Object Eplorer" and "Skript Object as ALTER"
    don't work together with Nicolas Ross' Schema Folders

    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  ·  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

14. Schema Folders

    Please introduce Schema-Folders in SQL-Server Object Explorer
    as shown in
    https://github.com/nicholas-ross/SSMS-Schema-Folders

    Or make SQL-Prompt working together with
    https://github.com/nicholas-ross/SSMS-Schema-Folders.

    The Features "Show in Object Eplorer" and "Skript Object as ALTER"
    don't work together with Nicolas Ross' Schema Folders

    0 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  ·  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

15. Fix this bug with your software and Visual Studio 2017

    Have it not break Visual Studio 2017 even when selecting that you don't want it to be integrated with it.
    The problem is that we could no longer get latest version after installing your software and then rebooting. Here is an email that I just sent to a group of people that have had the issue for at least a week before we narrowed the problem...

    Guess what!?

    We found what caused the issue, can reproduce it, and fix it.

    The issue is with Redgate’s software, specifically SQL Prompt for us.
    This is the reason that John never had the problem and I wound up with the problem 5 weeks later and Craig had it from the beginning.
    • Craig has always had SQL Prompt installed on his machine and he always had this issue.
    • Approximately 5 weeks after installing VS 2017, I installed SQL Prompt and then began having the issue.
    • John never installed any RedGate software and therefore never had the issue.

    Today, Craig reinstalled SQL Prompt and the issue came back. He deleted the same folder that we suspected is the resolution to the issue and the problem went away.

    I, Ray, went to verify that this was truly the problem and installed SQL Prompt and then I started getting the issue again myself. I removed the aforementioned folder again and the problem went away.

    In summary, you can run SQL Prompt but after installing it and rebooting, you have to remove the aforementioned folder for the problem to go away again.

    Cause of Issue:
    RedGate SQL Prompt

    Resolution:
    Refer to previous email regarding the folder to delete.

    Have it not break Visual Studio 2017 even when selecting that you don't want it to be integrated with it.
    The problem is that we could no longer get latest version after installing your software and then rebooting. Here is an email that I just sent to a group of people that have had the issue for at least a week before we narrowed the problem...

    Guess what!?

    We found what caused the issue, can reproduce it, and fix it.

    The issue is with Redgate’s software, specifically SQL Prompt for us.
    This is the reason that John never had the… more

    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  ·  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

16. Create package for Visual Studio Code

    Visual Studio Code has the ability to connect to SQL servers and execute scripts. It would be nice if SQL Prompt was available for Code as well.

    84 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

    13 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