ChristianASP.NET Blog - SQL

Red Gate SQL Prompt is FREE!

David Neal — Tue, 23 May 2006 13:09:58 GMT

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.

Prompt SQL is now Red Gate SQL Prompt

David Neal — Thu, 04 May 2006 17:46:40 GMT

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.

Oracle 10g Express Edition Released

David Neal — Tue, 28 Feb 2006 04:28:28 GMT

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.

VistaDB 2.1 database for .NET has been released

David Neal — Fri, 28 Oct 2005 03:14:00 GMT

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!