Awesome!  Red Gate has released SQL Prompt, and it's FREE!  Get Intellisense for Query Analyzer, Enterprise Manager, SQL Management Studio, and Visual Studio 2003/2005.  It even supports UltraEdit and EditPlus.

SQL Prompt can also automatically upper-case SQL keywords, and provides a code snippet engine.

I absolutely love Red Gate's SQL tools, and can't say enough good things about them.  I just found out from Steven Smith that Red Gate have purchased Prompt SQL (intellisense for SQL), and there's a beta to be downloaded that supports SQL 2005 Management Studio!  According to the beta support forums, the plan is to sell SQL Prompt for $50/user with multi-user discounts at 5- and 10-user levels.

By the way, Red Gate's Profiler and Load tools are incredible, too.

Annoucement link.  "Free to develop, deploy, and distribute" and suited (among other things) for "developers working on PHP, Java, .NET, and Open Source applications."

According to the FAQ, the Express Edition has the following limitations:

• Limited to 4GB of user data
• Only one instance per server
• Only executes on one processor if running on a multi-processor server
  
• Will only utilize 1GB of memory, even if the server has more

Oracle 10g Express Edition comes with a "browser management interface" which I assume is better than Microsoft's MSDE command-line OSQL.

My company is considering Oracle as an alternative product platform, so I'm sure I'll be giving this a try sooner or later.

Wow... this looks great.  I can already think of several little utilities I've built where I could have used VistaDB, but ended up using XML files or the like.  I gave up on using Access a long time ago, and MSDE is a bit overkill for small apps, especially in regards to deployment.  Microsoft has recently deprecated the Jet engine, so VistaDB appears to be poised to fill a much needed void.  I'd be very interested to see if VistaDB will integrate well with WilsonORMapper and NHibernate.

This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio .NET 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, data management and data migration tools. Free trial is available for download.

- Learn more about VistaDB
- Repost this to your blog and receive a FREE copy of VistaDB 2.1!