663 results found
-
save /copy result grid as html table
SQL Complete has a great feature to allow copying the result as html table. I wish this feature was available in RedGate. This is the feature I would use multiple times every day.
1 vote -
"Open in Excel" feature should use the default Excel template
In the "Open in Excel" feature, I'd like the resulting Excel workbook to auto-open using the default Books.xlst template file locatedi in the %AppData%\Roaming\Microsoft\Excel\XLSTART folder.
1 vote -
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
1 vote -
Release notes
When you do a new release of SQL Prompt it will popup thru the existing install of SQL Prompt saying that there is a new release. There is a link on there to the release notes. PLEASE UPDATE THE RELEASE NOTES WEBSITE TO DESCRIBE THE NEW RELEASE. The website is usually a version behind. The problem is there is a new release and no idea what it fixes or addresses.
Just installed Version 10.14.11.7894 and I do not know why...
1 vote -
Add menu item that collapses all servers in Object Explorer
After I connect to multiple servers at one time using the Registered Servers window, the connected servers appear expanded in the Object Explorer window, and then I manually collapse each one. I also find myself scrolling up and down in the Object Explorer window to manually collapse servers I've expanded throughout the day. A menu item to collapse all of the connected servers in the Object Explorer window would be a feature I would use quite often.
1 vote -
Please re-implement rule DEP001
We extensively use this rule in our organization.
1 vote -
Script as UPDATE
Where Script as INSERT takes the selected table values and puts them into #temptable
The 'Script as UPDATE' knowing which field is the PK would instead of creating something like
`INSERT INTO #temptable ([Id], [BrandId], [Key], [Value])VALUES ),()... would create
UPDATE #temptable SET [Key]='', [Value]='' where [Id]=101 and [BrandId]=1
This would make creating the Down Migration scripts used in EF easy as will as a quick UNDO safety net when running scripts is pre-live or live.1 vote -
Detect variable declared in potentially unreachable scope
Unlike a proper programming language TSQL allows you to declare a variable inside an IF block (or some other scope) and then use the variable outside that IF block, even if the IF block is not entered during run time. This can lead to errors if the code outside the IF is testing for certain values.
It would be good if Code Analysis could detect this as a potentially dangerous coding structure.
E.g.
IF 1 = 0
BEGIN
DECLARE @Var VARCHAR(50) = '123';
END;
SELECT @Var1 vote -
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…
1 vote -
Show number detail of Result Grid selection(s)
When a column(s) on the Results Grid is selected, show the Count, Distinct Count, Avg, Min, Max, Sum of the data in the column(s). Make it an option as to what to show by default, but with the option of widening or narrowing the aforementioned data.
1 vote -
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 -
Option to apply custom aliases (without assigning new ones)
I have a handful of tables/views I use the same aliases for. I want to have SQL Prompt add those aliases when it completes the table/view name, but not automatically create new aliases for all of the other tables/views
1 vote -
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…
1 vote -
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 -
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 -
Update formatting rules to handle ORDER BY inside an OVER expression
I had a query which was using ROW_NUMBER() OVER (PARTITION BY ColumnA ORDER BY ColumnB, ColumnC) and FORMAT SQL command put the ORDER BY clause as the first thing on the line (no indentation). It would be better if, when it needs to be wrapped, the ORDER BY inside an OVER was indented to line up with PARTITION BY).
1 vote -
Snippet manager improvements
Love the snippets functionality, but four improvements would be nice:
1) Fix bug that if you click off a snippet to other windows before finishing it that it will lose everything you've entered and switch back to default values for everything.
2) Add an option to finish a snippet when you tab past the final value instead of cycling back to the first snippet.
3) When you hit ESC to exit a snippet, leave the cursor where it is instead of jumping to the end of the snippet.
4) Allow user to define where the cursor should go when exiting…1 vote -
Column Order when expanding pivot is reversed
I've noticed that when I Expand * on a pivoted table, then the order of the columns gets reversed
e.g.
If I have something with a pivot
Sum(Amount) for month_no in ([1],[2],[3]....)
When the pivot result is expanded, it becomes [12],[11],[10]....
Would be nice if the expansion would match the order that the columns was entered in.1 vote -
Database-specific snippets
Database-specific snippets.
We have 80 or so databases scattered across 200+ instances and many tables have similar names or identical names with differing schemas: compare person.personpe, dbo.person & finance.personpe. This particular is extreme and there are more examples but the principle applies.
I would love to be able to define pe as a snippet at a database level so that I can keep my snippet names short and so that I don't have to rename them manually when I am in SSMS with a lesser used database.
1 vote -
Find Invalid Objects - Database Drop Down list not wide enough
The Database drop down needs to be dynamic in width or allow us to pull it wider. It is extremely difficult trying to find the database I'm working on when I have multiple installed in a LocalDB environment.
1 vote
- Don't see your idea?