I usually go with HW RAID 5 for my installations. If database performance is an issue you might choose RAID 1.
Note, there is also a scheme called RAID 0 (data striping). It offers the greatest throughput because reads and writes are split between multiple physical disks. Unlike other RAID types, it offers no data protection.
If you choose the HW method you usually install the controller, then install the driver. Most ctrl have a BIOS extension control program that you invoke during POST. If you plan on booting from the RAID you must use the BIOS program to initialize the disks and create containers. If you are just going to use the RAID for data you can use the ctrl's Windows tool to manage it.
If you want to boot from the RAID you usually have to boot from the Windows installation media, then install the RAID driver when prompted for a third-party disk driver. Initialize the RAID containers from Windows as if they were regular disk drives.
If you choose software RAID, the Windows disk manager help has complete instructions.
Adaptec has extensive technical information on their web site. Other RAID vendors should also provide technical info.