Geeks With Blogs

News Dave's Mug View David Oliver's profile on LinkedIn Add to Technorati Favorites Blog Directory for Guildford, Surrey
Dave Oliver's Blog Enterprise Technology Thought Leadership in a FTSE 100

As normal service has resumed and I’m blogging again (admittedly I’m not going to blog about absolutely everything) here is a wonderful little utility I found on my travels for adding Intellisense to editor in SQL Server. It’s called promptSQL from Red Gate. I really love how Intellisense makes me more productive (i.e. lazy) in Visual Studio and I was wondering about its rather obvious admission from SQL Server 2005 Management Studio, missing a trick strings to mind. Anyway for $95 you can have it in all its glory. Yep, $95 which seems a bit steep, it drops to $50 per head when you buy 10.

Another little gripe is that options in the drop down window are selected via the return key; the space-bar just generates a space. I’m very used to using the space-bar so it’s going to be weird going from one Intellisense to another.

The software can be eval’ed for 14 days and is still in beta but it hasn’t blown up on me yet.

Posted on Monday, May 8, 2006 12:30 PM Main | Back to top


Comments on this post: Intellisense in SQL Server 2000 and SQL Server 2005 editors

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
You got to check out SqlAssist from http://www.roundpolygons.com.

Get Intellisense and more for $29 and very stable so far for me.
Left by Shawn Cicoria on May 08, 2006 6:14 PM

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
.... I just have !

.... and it's awesome !

The only issues are that it doesn't yet integrate into SQL Server 2005 editors yet, but this is coming, and there are no plans for a SQL Server 2000 version.
Left by Dave Oliver on May 09, 2006 10:18 AM

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
Left by Mental Health on Nov 24, 2006 8:30 PM

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
SqlAssist does integrate with Sql Server 2005 editors now. Full release, and working great! This definitely is a must have for me...
Left by Jon on Feb 20, 2007 3:49 AM

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
Yes, for my money, SqlAssist is the one. It's intellisense rocks, and it has several other nice little features too (like a built in pretty formatter for example, and correct case as you type!). After testing SqlAssist, I don't see why anyone would spend $95 on Sql Prompt.
Left by Tim on Mar 22, 2007 5:41 AM

# re: Intellisense in SQL Server 2000 and SQL Server 2005 editors
Requesting Gravatar...
I was reading up on comparisons between SQL Prompt and SqlAssist, and I just can't see paying 200 bucks for the former!

To SqlAssist I go!
Left by Wayne on May 29, 2007 7:58 PM

Comments have been closed on this topic.
Copyright © Dave Oliver | Powered by: GeeksWithBlogs.net