668 results found
-
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 -
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 -
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 -
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 support for Fabric warehouses and lake houses
Add support basic intellisense support for Fabric warehouses and lake houses.
22 votes -
New Case When Intend option
The new option would allow intending from alias (in alias = expression notation)
5 votes -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
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
- Don't see your idea?