5 results found

1. "Prompt AI" allow more database objects, or a defined lists of schemas

   Tried to test out the new Prompt AI feature and cannot use it to generate SQL as the DB has more than 4000 objects (over 6000 actually). It would be great to limit the schemas within the DB where I want the AI tool to "know about" so that A) it keeps the AI focused on just the schemas it needs to answer most questions and B) it keeps the overall list of objects and time needed to poll them more manageable. In absence of this, allow more objects.

   4 votes

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

   Submit Rating

2. Turn off SQL Prompt+ AI

   Please can there be an option to turn off SQL Prompt+ AI. It is a pointless feature that I have found no benefit from. It locks up and crashes SSMS. It also it an extremely intrusive feature constantly displaying the icon next to the cursor

   2 votes

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

   Submit Rating

3. AI to help detect databases/schemas most often used?

   I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:

   https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory

   So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?

   While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that there would be an AI (or some "smart feature" that would automatically suggest which databases and schemas etc that I use the most, so I that I could just accept?

   This is by no means a deal breaker, but just a "nice to have" feature. Just wanted to let you know, and that I other than this like SQL Prompt :)

   I got a suggestion from SQL Prompt for "Slow cached time detected".The link (seen in the screenshot) was this one:

   https://documentation.red-gate.com/sp/managing-sql-prompt-behavior/managing-connections-and-memory

   So from what I understand, I need to manually go through all databases and schemas and select the ones I think are used to the most in order to only load suggestions for them, in order to improve performance?

   While I generally like SQL Prompt, the first word that came to mind was that this pretty much sucked, but let's just say it's less that optimal I think. Given that we’re in the ”AI age”, I was hoping that… more

   •  

   1 vote

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

   Submit Rating

4. 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 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  ·  AI  ·  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

   Submit Rating

5. Add AI assistance

   As AI powered tools like codepilot, kite or tabnine are on the rise, It would be so great to add an AI assistant to SQL Prompt to support developers on their way to write t-sql code effortless.

   3 votes

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

   Submit Rating