Yes. All kernels in the 2.6 series have support for SATA (though the distributor may not have compiled them in). The later 2.4 kernels also have SATA support, but many distributions (Damn Small Linux is the only current one that uses a 2.4 kernel anymore) don't have it compiled in.
Almost all modern desktop distributions (Ubuntu, Debian, Fedora, OpenSUSE, etc...) have support for SATA built-in.
a sata power connector is normally used for powering sata dvd drives as well as sata hard drives and ssd drives
SATA hard disks are basically hard drives or optical disk drives. The prices an SATA hard disk for them vary from $50 to $200. They can be found on a variety of websites online.
How many can you put in your computer? Linux can support massive servers with hundreds of hard drives. I believe the mainline kernel supports up to 702 hard drives, although patches are available for up to 3904 disks. You're far more likely to run into hardware limitations than you will with how Linux handles hard drives.
SATA, or serial advanced technology attachment, connects the motherboard to hard drives and optical drives. This cable is inserted into the SATA slot on the motherboard.
Yes it does. 6 xSATA 3 Gb/s
Yes, SATA is used to connect the hard drives to the motherboard.
24 bay SATA storage server hard drives can be bought on eBay. The online company Servercase also has new 24 SATA hard drives as does Thinkmate, at a considerably greater cost.
Someone can purchase a SATA hard drive from a number of companies such as Amazon. Amazon has a large selection of SATA hard drives from a number of manufacturers.
sata
Yes, you can. If your computer has more sata ports you can use then to connect more hard drives.
molex for IDE devices and sata power connector for SATA devices
You should check the exact type of your SATA drives, and what cables they require, on their website: SATA drives come as SATA-1 and SATA-2, and also as E-SATA [external SATA], I believe. The cables may be different, check it out on Wiki or your mfrs site. cheers!