And if you want, you could break it out even more with a SATA Expansion card in combination with the SAS HBA adapter, this card can be run on a riser, just requiring power.
Also more information about the different models. You should look for one that says “no BBU” in order to be able to flash it. But I think some models just work out of the box. Only I had to flash the Dell one.
so what would be the advantage of using this method over a bunch of powered usb to sata adapters? or cheap enclosures with adapters built in? other than cost of course. write speed maybe?
I got a Corsair Obsidian 750D that can fit up to 16 3.5" HDDs. I like to have my setup compact and clean. Also, powering every single USB drive with its own power adapter is highly inefficient. I just have a 750W PSU for everything. Powered USB to SATA are maybe a bit more efficient but still, a lot of cables. BTW those LSI cards are designed for servers with an optimal airflow. They tend to get really hot, like burning to the touch. I am thinking about attaching small fans with cable ties on top of their heatsink.