I use VPC 2007 to do development in all day long at work. Visual Studio 2005, SQL Server, etc. Runs great! You can't play 3D games, but that is the only limitation I know of.
One tip though, you need a fast HDD. If you have more than one HDD, put your VPC images on your non-OS drive.