SATA modes explored: AHCI vs. IDE
A little bit of out of date but I had to rethink through the advantages of NCQ, hot swapping and re-explore this topic over the weekend when I was pricing out hard drives for NAS. I wish I read this article years ago because it goes into very good detail regarding AHCI mode on SATA controllers.