try browsing this link
Sony has some serious Brodcast quality equipment
But, as with anything Sony, once you start buying equipment from them you are stuck in thier world (compatability) and you better have a lot of money
As for software - any major piece of software is used, PC and apple platforms, 'Hardware' editors (Tape splicing and frame editing directly from tape...) and many flavors of highly custom and proprietary software depending on the studio.
Most production studios and advertising agencys will have a variety of hardware and software to work with.
My System Specs:
Cameras: 2 x Canon XL1s
Computer: Dual Intel Xeon 2.8Ghz processors (hyperthreaded) - Intel SE7505VB2 mother board - 2 Gb PC2100 RAM kingston -Adaptec FireConnect 4300 -2xseagate 10K scsi hdd 150G ea -2xseagate 7200 ide hdd 200G ea - Plextor PX-708A DVD burner - ATi Raedon 9800Pro video with Dual SUN 21\" monitors - Sound Blaster Platinum live!
Software: Windows XP Pro with SP2 - Pyro Pro (adobe\'s premier pro, encore DVD, and audition bundle)