InteliSense alternative – SQL Complete
I just wanted to post a blog entry for this tool which is well worth a look – particularly so if you’re working on SQL Server 2005 and currently don’t have use of any IntelliSense.
SQL Complete is free and saves you key strokes (which is always good!). I find it’s particularly good to pass on to developers as well as it encourages them with certain practices – to schema qualify for example.
We’re moving up to SQL Server 2008 R2 at the start of next year (I know – we just missed Denali!) and I was using the InteliSense in this edition, and I must say I even still miss SQL Complete now I have InteliSense! I find it extremely useful as I don’t have a great memory for object names. So I can type SELECT * FROM org and it filters down it’s suggestions to objects like ‘%org%’, so dbo.Organisation, vwOrganisationDetails etc will all show – which the inbuilt InteliSense in SSMS currently doesn’t do.
Here’s a link to the Free Edition for your consideration: http://www.devart.com/dbforge/sql/sqlcomplete/#tabs-4