673 results found
-
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…
21 votes -
SQL Rule/Issue/Error Search
Like SQL Search, but SQL Error/Issue/Rule violation.
This would list all issues that exist in a database.
Example: "Non-scalar subquery in place of a scalar value"Because these issues can cause major slowdown in queries, and it would be great to have a way to search a whole database to find these rather than having to open all the views, procedures, and functions to find all these things.
2 votes -
New Case When Intend option
The new option would allow intending from alias (in alias = expression notation)
5 votes -
IntelliSense for $partition.<partition_functions>
I would like the Prompt to be able to list any partition function found in the current context (DB)
like when i write: $partition.<Intellisense here>1 vote -
In the SQL History tab, under Advanced Search, allow us to set a default server and database
In the SQL History tab, under Advanced Search, allow us to set a default server and database or remember the last one that was chosen. I have about 30 servers in my list and most of them no longer exist. I would never want to search all servers. I would also rarely want to search another database besides the one I usually search.
2 votes -
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 -
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.
6 votes -
"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 -
Formatting Styles should include Global Style parameters
Global formatting options like "Insert Semicolons", "Add brackets to all identifiers" etc should be part of a formatting style, this way changing a formatting style can also quickly switch between these options.
Currently even after changing a formatting style these options on the screenshot below had to be manually changed one by one, it's inefficient to say the least.3 votes -
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 exampleE46337E5-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-79B21A628538turn 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…
6 votes -
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 -
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 -
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.
2 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 -
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…7 votes -
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
- Don't see your idea?