SQL Prompt Pros and Cons

A no-hassle tool. SQL Prompt provides useful intellisense suggestions that go way beyond the scope of what the bog-standard SSMS environment provides. Redgate have found a niche in the market where Microsoft refuses to elaborate, and I commend them for that. There are a plethora of features, most of which I probably don't use to the full extent, but suggestions for the sprocs to call, auto-filling of code, auto-formatting, casing, efficiency/code-standard suggestions, and even allowing to peek at sprocs if you need to just quickly view some previously written code are invaluable for saving time. On top of that, the environmental feature that allow you to colour-coordinate your environments is an underrated perk that's useful for when you are making SQL changes in different areas. I use SQL prompt every day as it slices the amount of development time for tasks. Some would argue that SQL prompt is a crutch, and I have to admit I wouldn't be without it now, but there's a reason for that, and that's simply because it's too good to pass up. Review collected by and hosted on G2.com.

SQL Prompt can be quite resources intensive at times. I have no issues with the product as a whole, but the SQL history feature can really bog down my workstation.This is definitely a minor greviance in the scope of the product however. Review collected by and hosted on G2.com.

When I changed organizations and lost access to SQL Prompt, I immediately decided to purchase it myself. I rely on its formatting and snippets every day. My new team also started using Prompt. Review collected by and hosted on G2.com.

Maybe I use it too much now. If I have to write all syntax correctly without it, I might lose my job. Review collected by and hosted on G2.com.

SQL Prompt's SQL syntax type-ahaead, smart column suggestions, alias resolution... you name it: these features come in so handy and natural you only immediately notice when they're not there (because you launched the wrong instance of SSMS). I don't want to work without it.

As for time saved, this thing literally pays for itself. Review collected by and hosted on G2.com.

With the usual underpowered terminal server virtual desktop session, performance can be just a tad sluggish at times, particularly at startup. Review collected by and hosted on G2.com.

I've been using SQL Prompt for years. The autocompletion, formatting, tab colors, snippets and other features are fantastic. I can't imagine using SSMS without it. Review collected by and hosted on G2.com.

I can't think of any downsides. Just a great product and company. Review collected by and hosted on G2.com.

It has quite a few useful features, but my favorite by far is the T-SQL formatting. Review collected by and hosted on G2.com.

Nothing, really. It's a truly great product. Review collected by and hosted on G2.com.

SQL Prompt is where I need it. It's quick and helpful. Review collected by and hosted on G2.com.

It does not handle well SQL upgrades. Recently upgraded instances to SQL 2022 and users reporting crashes. Need to upgrade SQL Prompt, but this could be potentially handled better. Review collected by and hosted on G2.com.

It integrates with SSMS the way a DBA would expect. Review collected by and hosted on G2.com.

Really no negatives, very straightforward as a tool. Review collected by and hosted on G2.com.

The ease of use and speed at which you can write code is exponentially faster. I'll never NOT use it. Review collected by and hosted on G2.com.

There isn't really anything that I would change. Review collected by and hosted on G2.com.

It's ease of use, wide variety of features (Intellisense, SQL History and Snippets being in the top, Code Formatting), and the excellent and seamless SSMS integration. Review collected by and hosted on G2.com.

Formatting could use a bit more flexibility in defining the style.

And the fact that Azure Data Studio still doesn't have a full version... And possibly never will? :( Review collected by and hosted on G2.com.

It is vastly superior to SSMS' built-in tool for command completion.

It saves me a LOT of typing. Review collected by and hosted on G2.com.

SQL Format has changed recently and now sticks tabs in odd places. I have to review any script that I have re-formatted using SQL Format. Review collected by and hosted on G2.com.