We would see those applications on any current machine.
However I would try Dell's business laptops with the ones you have downgrade rights to XP Pro if you get bound up into a corner with Vista.
More at http://www.google.com/search?hl=en&q=vista+downgrade+rights
Remember we used to run such demanding things on 1GB RAM, XP Pro, single core machines. You will likely get dual core and 3 to 4 times the ram so I won't call this demanding.
Bob
We are looking buy few portable laptops that can run high end applications. Any recommendations.
Some of the tasks we perform using the laptop will be - photoshop, dreamweaver, visual studio, developer edition MSSQL server, MYSQL.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic