How to run PHP pages on IIS 7.5 or Windows 7

This guide has been updated and rewritten as the easiest way to successfully Configure IIS 7.5 to work with FastCGI and PHP on Windows 7 is to use

Microsoft Web Platform Installer 2.0 from http://www.microsoft.com/web/Downloads/platform.aspx

Why?

The installer does all the hard work

No more downloading PHP then configuring the php.ini file

No more going into your Internet Information Services (IIS) Manager and adding a Handler Mapping FastCGI Module

No more going into your System Properties and setting up your Environmental Variables

No more spending endless hours surfing around looking for solutions that help you get it all working (it rarely happens first time)

Forward mail from rediff mail to other email address - Rediff Bug

If you want to forward all your emails from your Rediffmail account to any other email account, simply follow the steps below:

Go to the classic version of your Rediffmail account. This is important else you will get an error

You have not specified any email address to which you would like your emails forwarded

Disable or Stop Auto CHKDSK During Windows Startup

One of Windows annoying so called “feature” is CHKDSK being automatically being run whenever you don’t shut down your computer properly. You get the blue colored screen that says “Checking file system on C: The type of the file system

Excel 2007 slow to open files

I think I am one of thousand people who upgrade MS Office to be MS Office 2007 and got pain for MS Excel to slow open file. It takes more than 1 minute. although there are no any add-in was installed and my file is very small in KBs.

HENCE, MY SOLUTION FOR THIS PROBLEM IS JUST INSTALL AN ADD-IN OF EXCEL 2007. You did not need to install all add-ins. Just install only one add-in and see the effect.

Viewing the disk space usage (size) of all the tables in a SQL Server 2005/2008 database

I spent a couple of hours searching for a script that returns the size of all the tables in a database. Most of the ones that you find use sp_msforeachtable but that is just for one table and you then need to use temporary tables to hold the values.

This article on the Database Journal by Ananth Kumar (AKA MAK) had this handy script that simply works by copy-pasting it as is. Read the linked article for details on viewing the size by schema.

How to Enable or Disable Hibernate in Windows 7

Hibernate feature allows operating system to save and write the running state and contents of RAM as a file or partition to non-volatile storage such as a hard disk, before powering off the computer. Hibernation allows system to quickly restart and restore to original state when hibernation was invoked, instead of having to close down and start up all the running programs again.

In Windows 7, hibernate option should be enabled and turned on by default, However, if you can’t find Hibernate option in the Start menu power button, the steps to enable Hibernate in Windows 7 is easy, and is the same with Windows Vista.
How to Turn On and Enable Hibernate in Windows 7

Make your own VGA cord of CAT5 cable!

i

As most of you know, getting a descent length of VGA monitor cable is a costly thing. With this instructable I'll show you how to make a 15m long VGA cable, out of plain ol' CAT5 network cable.