Add in httpd.conf:

<VirtualHost 127.0.0.1>
   ServerName mysitename.local
   DocumentRoot E:\path\to\files
</VirtualHost>

Add in C:\WINDOWS\system32\drivers\etc\hosts :

127.0.0.1 mysitename.local

Restart Apache.

Now if you write mysitename.local in firefox it will take you to whatever is in E:\path\to\files.

Later edit:
You may also have to:
uncomment LoadModule rewrite_module modules/mod_rewrite.so
put in this line: NameVirtualHost 127.0.0.1

I found a very funny picture a while back at goflash.org/team.jpg. But it seems to have disappeared. Luckily i still have it around. If there's any copyright problem let me know where i can link to the original and I'll take it down.
developer - born brave:

In case you have to work from the command line (ssh?) and you need to run a lot of queries, instead of just running them one by one you can put your sql statements (inserts, updates, queries or whatever) and use:

shell> mysql db_name < text_file

If you have "use db_name" as your first line in your text_file you can just youse
shell> mysql < text_file

If you are in mysql you can use:
mysql> source file_name

If you work with cookies and you need to edit your cookies or delete only some cookies fast you can use Add N Edit Cookies, a firefox add-on. Thing is a "cookie editor".

What this script does is it makes a div, it attaches it to the dom, in puts an iframe inside the div, and then it writes things inside the iframe.

I had a problem with an iframe once that although had 0 width and height would still show up on the page. What finally did the trick was the marginheight attribute set to 0, marginheight = "0". Hope this helps if it happens to you.

Ie6 has a big problem with transparent png's.
Here is a fix:

<div style="filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src='image_path')">

<img style="filter:progid:DXImageTransform.Microsoft.Alpha(opacity=0);" src="image_path" />
</div>

Sometimes you need a file manager for windows. When those times came, i found total commander to be rather useful.
You can do nicer searches then the windows default features provide. You can search inside multiple files with it and you can compare two files.

A nice firefox add-on i have so i can immediately judge how much traffic a website has and how important it is, is search status. I got so used to it I find it hard to browse without it.
From the description:

Display the Google PageRank, Alexa rank, Compete ranking and SEOmoz Linkscape mozRank anywhere in your browser, along with fast keyword density analyser, keyword/nofollow highlighting, backward/related links, Alexa info and more.

This one time, in band camp, when i was working on a javascript... script i needed an equivlent for the include_once in php. It was very likely that the code where i was including something got to run multiple times, and this caused problems.
So i found the solution on phpied.com.
So here it is, the php include_once equivalent for javascript:

var included_files = new Array();

function include_once(script_filename)
{