Mischa Kroon

Aptana is a free / open source project built on the eclipse RDT environment.

It's main focus is on javascript.

For which it brings a nice code completion / information interface and delivers hints and code completion for:

• Javascript
• CSS
• and HTML

There are also quite a few videos about how well it supports the different Javascript libraries out there.

You can check them out here.

Now your probably thinking of Thunderbird when you read this but there is another option out there.

Evolution.

Evolution is created by Novel and is ported to Windows.
It has been available for a while and it now also has an installer for windows, which makes it a whole lot easier to install.

You can find the project page here:
http://shellter.sourceforge.net/evolution/

And offcourse the: Features and the Screens

Personally I was a bit surprised to see it ported but it looks like a decent mailclient and should give thunderbird and outlook express a run for their money.

When looking at the following code:

StringBuilder first = new StringBuilder();
StringBuilder second = first;
first.Append ("hello");
first = null;
Console.WriteLine (second);

What would you think the output would be ?
If it is anything other then: hello

You will want to look at the following tutorial:
Parameter passing in C#

Information_schema is a part of the information stored in the database and is the preferred gateway to this information.

It's a sql 92 standard, which means that it's supposed to be standard but every database is bound to have it's own implementation of it and will do things differently.

Some of the differences of MSSQL 2000 vs the standard and basic information.

Ok now we know what it is are what can we do with it :)

Well we can look up with the help of some dynamic sql, where for instance one term is in all the tables of one database.

We can use it for one of the things most people do with it.

We can use it to do bulletproof updates of database schema's.

We can use it to tell differences between schema's

Build all in one change tracking solutions.

Build little utility scripts.

Offcourse a lot of stuff is also available through a ADO.Net interface which is through the use of "GetSchema" in .Net 2.0, the main advantage of this interface being that it's sort off database independent. This is because it is provided through .Net database drivers.

More about GetSchema can be found here

All in all the INFORMATION_SCHEMA brings us a lot of power in terms of database information and can be used for a lot of different purposes.

Discusses common errors about:

Caching and forms authentication
View state and session state
Profile property serialization
Thread pool saturation
Impersonation and profiling