-
Redgate Free Tools
I've seen a lot of people rave about in the past. They provide a really nice set of tools that are well worth spending sometime to check out. They have a promotional offer available now where you can download their new SQL Prompt Intellisense tool for free until September 1st (note: it does not timebomb after that date - so you can use it forever). This tools provides intellisense completion for writing SQL queries and looks very useful: You can learn more about it and download it for free. Hope this helps, Scott.
Red-Gate SQL Query Intellisense Tool (Free Download) Monday, May 22, 2006. I have been using RedGate SQL tools for about 2 years now and I love them. I found out about this tool in one of their newsletters. BTW, SQL Prompt version 2 was free, new version 3 cost $195 per license. Margos - Thursday, February 22.
16 Comments. I've used this - it's purty neat!! -. This is an interesting tool, but people should evaluate it pretty carefully. It runs as a separate process, since QA doesn't really support a plug-in model. That means it presents an icon in the desktop tray and runs even when QA doesn't. The first time you connect to a database, you'll need to set up a connection in the Prompt tool.
You can set up databases on the same server to use the same credentials if you want, but each time you use a server for the first time you'll get kicked out of QA into the Prompt connection manager to connect. Finally, it seems a little brittle to me. Changing table or view aliases after resolving the suggestion list the first time seems to confuse the product, and using an alias for a table or view that is the only one included in a query doesn't seem to work all the time.
HOWEVER - it is a great idea, and it is a very useful tool. I also personally recommend Apex SQL Edit - it's a good tool with auto-completion and supports fun things like unit testing, integrated source control and other fun things.
Not a commercial endorsement, just an avid fan and user. Dwain Gleason -.
I've always been frustrated that when I press Ctrl-Space in SQL Query Analyzer it doesn't do syntax completion like Visual Studio does. Well, now it does. SQL Prompt only work with English language versions of SQL Server -. Scott, I don't know how to thank you!!!
This is what I was looking for in so many time. This is just Great. Thanks -.
Free Tools Samples
This tool worked nicely in SQL Server Management Studio, and performed all the tricks shown in that animated gif. Except one: when I type PRINT @@ I don't get any intellisense. I think the objections expressed in a few of the other comments are a bunch of hooey. I'm definitely going to get benefit from this tool.
EricTN -. hi scott, thanks for the link. The tool works great with sql server management studio. It definitely is gonna help me for sure. As for the marketing problem as written above by paul,well i would only say there is no free lunch! U can always give fake info to register!!! Srinivas -.
Is this tool, used for local databases only or for the databases existing on the servers as well. Because i could not observe the intellisense when i used it on the server. AVL Narayana -. I have tried Prompt Sql 1.2 in the past. It costed USD 25.00 It was a bit flaky. Its SQLPrompt now.
Now I see the same product packaged with Red Gate Logo with a slightly different Options screen. I wonder when Microsoft with release a true intellisense SQL Editor. Otherwise, its good as long as its free.
Arnab -. Yep, it works for remote databases, too. Even worked for me over the internet, no less. You may need to be enable tcpip to the database, or start typing a query and hit ctrl-space. Then you'll get a prompt to log into your remote database.
I thought it was cool how it auto-completed inner joins with the relevant keys/foreign keys. I have been using RedGate SQL tools for about 2 years now and I love them.
I found out about this tool in one of their newsletters. The newsletter indicated that it was purchased technology, that RedGate will work over and charge for later. So, don't delay, get it now. As soon as I tried it out, I was hooked. I shared it with everyone in my office and everyone has had nothing but raves so far. Ned Stick -.
A nice tool to fill the gap between now and the RTM of the LINQ project:) -. I am speechless.
This should have been around a long time ago. Thanks for the link. Hi there, A comment above states that SQL-Prompt will only work in English versions of the Query Analizer only. Is that True? I tried it in my Spanish QA and it's not working. Thanks you Mr D -.
BTW, SQL Prompt version 2 was free, new version 3 cost $195 per license. Thank you Margos -. Does anybody have the Version 2. Can anyone share it please. I had it on my disk and my partitions got messed-up. So dont have the HDD anymore.
Appreciate if anyone can help on this.
I've recently started delving into SSMS Addons. I'm really loving RedGate SQL Prompt 5 (refactoring/better intellisense), though it's spendy.
The trial is going swimmingly. With that I like RedGate SQL Search (Free) and RedGate Tab Magic: also free and a godsend. That said, other nice tools: SSMS Tools Pack: Or as free (but not as nice as RedGate's offerings, IMHO)(They 'seemed' slower and I like RedGate's code formatting better, I never could tune Apex Complete's to be just how I wanted it.even though there were vastly more options.) are the ApexSQL Free tools: (Apex Complete, Apex Refactor, Apex Search) Does anyone else have any 'must have' tools for SSMS they'd like to share? My latest find has been by devart. It's essentially intellisense on massive steroids. Besides all the vastly improved 'normal' intellisense business, you can do things like: alter procedure SomeProcedureNamePress TAB You hit TAB and it brings in the SPROC definition.
You can also hit F12 to go to definition on any object: tables, views, SPROCs, functions, etc. That takes you straight to the object in Object Explorer similar to the behavior in Visual Studio.
With those things alone I almost never manually go into Object Explorer anymore and that's a good thing:) There are lots of other included features that are found in other products, but having them all in this one add-on makes it my new favorite SQL dev tool. It's $120 US per license, with some discounts if you buy more. Think we paid about $95 per for 6 users. I know I sound like a total shill for the company, but I can't help it - it's changed the way I develop! I also use Red Gate's SQL Search (and SQL Monitor & backup, though not SSMS add-ons:). Used to use SSMS Tools Pack, but once it moved to a pay version that's when I moved on to a more robust add-on. Figured if I was paying for it I might as well try to get the most I could.
Free Tools At Harbor Freight
It's not as sexy, but beyond that I've got a number of helper routines I've written that I use nearly every day. I'm sure everyone has a stockpile of similar things, but it's always nice to have useful tools you made yourself:) edit: for clarity.