674 results found
-
Bulk Action - Qualify Object Names
Run Qualify Object Names operation without having to open each file in SSMS.
I want to be able to apply best practices in bulk. Opening individual files and running qualify object names is very time consuming. It would be nice to do this operation in Bulk on a folder or list of files.
4 votes -
Offer to do update when client is closed
Rather than reminding about updates, it would be helpful to offer the ability to do a pending update as soon the client has been closed, as Visual Studio now does.
4 votes -
Moving commas INDEPENDENTLY between front and end (for debugging mainly)
DAX Studio has a splendid feature that I think is missing from SQL Prompt and could be rather easily implemented. In DAX Studio one can switch with one mouse click between putting commas before or after the column names. The "before" option greatly speeds up debugging but such formatting should not be left in production. In prod we want to have commas after the column name. Would it be possible to add a quick action or option to SQL Prompt so that commas are immediately placed at the end or beginning of column names? I know there are formatting styles…
4 votes -
Add 'Reconnect All tabs' button
Great improvement (at least for me, but I doubt I am alone with this issue) to connect all tabs on opening SSMS would be to enable to invoke this on click/keyboard shortcut.
I am working through VPN and every disconnect means I have to close and re-open the app, losing pinned tab status and tab ordering.4 votes -
Make auto savings of my open queries in case the program suddenly crashes
Sometimes my SSMS crashes. The Crash recovery of the program is not good enough. Would love to see "auto save" option that will save the open queries to history each time I'm idle for few moments. It would be much easier to recover than reproduce
4 votes -
Add your software to Microsoft Windows Package Manager (aka WinGet)
There is a new toy in town. Microsoft Windows Package Manager https://github.com/microsoft/winget-pkgs
I expect you to add your applications there. Thanks in advance4 votes -
Export settings doesn't export snippets
When I export my settings, my own snippets are not exported.
4 votes -
Fix the confusing multiple usage of your company name
You should fix the use of multiple versions of your name (Red Gate | Red-Gate | Redgate | redgate | red-gate) across all software and communications. See attached picture.
We try to promote your products in our consulting company, but everyone uses a different name to refer to your company.
4 votes -
Ability to exclude certain objects (Procedures/Functions/Files...etc.) from being processed for a rule
Currently there is no way to tell Code Analysis to ignore this specific object for a specific rule which has led to several false positives and wasted time re-investigating how to address the issue in the object only to come to the same conclusion as before that this is one of the rare cases where breaking that rule is ok.
My example is we have one stored procedure out of a thousand where the use of a NVARCHAR(2) makes sense and is actually more efficient then switching to a NCHAR(2) for what the code needs to do. Unfortunately the procedure…
4 votes -
Draw line from begin to end of different colors
It would be nice to have colored lines that visually enhance the start / end of a while / if statement
4 votes -
Find invalid objects in multiple databases
Please could you add an option to check for invalid objects in multiple databases and to be able to export the results in either a single file or 1 per database. It's a real pain doing 1 at a time and manually selecting the results to do a copy/paste.
4 votes -
simple tabs (brent ozar)
https://www.brentozar.com/archive/2011/06/fixing-sql-server-management-studios-tab-text/
Brent Ozar wrote this tip back in 2011 and I cant believe i've been struggling with the horrible SSMS tabs every day for my whole career. would be great if SQL prompt has a button to change these settings for you or defaults these options when you install it.
the main reason being that they are buried away and if I wasnt aware of them then i'm sure many others aren't.
at the end of every day i have about 10 tabs open and i just close the whole lot because it's too hard and to go through them…
4 votes -
Custom Aliases - Ability to Alphabetize by table name
Custom Aliases - Ability to Alphabetize by table name
4 votes -
Support for MS Dataverse / CDS
Add support so SQL Prompt will work in SSMS when connected to MS Dataverse / CDS (Common Data Service - Dynamics really).
Right now, it fails since the (meta)data exposed probably isn't quite as complete as on a "full-scale" SQL Server database
4 votes -
I would like to be able to re-name a tab without actually saving it off as a sql file.
I would like to rename tabs without having to save them as a .sql file to the filesystem. I run with alot of tabs all the time and it gets very difficult if you don't name them to find a tab that has floated into the dreaded drop down arrow. Once its there I have to walk through the whole contents of the drop down list of query windows to find the one I want. With a simple rename of the tab that could be managed by the solution file. I would be able to label them and track them…
4 votes -
Cloud Backup of all SQL Prompt Settings
Hi guys,
SQL Prompt is great. What is less great is migrating from one computer to another (or rebuilding your machine / VM / whatever).
It would be super useful if we could have a cloud backup of all SQL Prompt settings, styles, and snippets which can be associated with our licence account.
When we do an install on a new machine, we'd then be given the option to restore settings from the cloud.
4 votes -
Show only column names in intellisense while doing SELECT
Its really annoying to see table names suggestions in the intellisense while typing SELECT statement. I feel its not the new feature but its the bug to be fixed.
4 votes -
Place space before END when collapsing shorter case statements
When collapsing CASE expressions shorter then XXX, the END has no space if there is a preceding parenthesis.
Example1 = CASE t1.Col004 WHEN 1 THEN t1.Col006 END,
Example1 = CASE t1.Col004 WHEN 1 THEN TRY_CONVERT(int, t1.Col006)END4 votes -
Parentheses positioning not honoured for all parentheses, eg constraints
Using the parentheses option "expanded, to statement" for DDL, I would expect a constraint to appear with the opening parenthesis under the start of the constraint (eg, the "f" in a foreign key constraint) as follows:
MyColumn int not null foreign key references SomeTable ( someColumn )But it actually appears at the end of the same line as the constraint, and the entire contents are indented from that position:
MyColumn int not null foreign key references SomeTable( someColulmn )4 votes -
flip between adding and removing square brackets
Add ability to add or remove square brackets without having to edit the settings for which direction you want it to go.
4 votes
- Don't see your idea?