663 results found
-
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 -
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.
4 votes -
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…
3 votes -
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…
8 votes -
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 -
Add a table alias as a prefix to selected column names
I would love an option where, after adding an alias to a table, you can add it as a prefix to all columns coming from that particular table at once.
Some keystroke like Ctrl + F2 would be nice.
3 votes -
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…6 votes -
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.
3 votes -
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.
8 votes -
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.
10 votes -
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 -
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 -
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 -
Allow LEFT, RIGHT, INNER and OUTER JOINS to be right-aligned to SELECT.
Currently, FROM, WHERE, JOIN, and ODER can all be right-aligned to SELECT when formatting SQL. However, if you introduce a LEFT JOIN, the LEFT keyword is right-aligned to SELECT, and everything else is pushed over to make room for the JOIN. This is hideous and makes no sense.
Instead, allow the entirety of "LEFT JOIN", "RIGHT JOIN", "INNER JOIN" and "OUTER JOIN" to right-align to the SELECT keyword.
The attached images explain it better than I can.
6 votes -
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 -
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 Trimmer3 votes
- Don't see your idea?