I think it's more a performance benefit to have MSSQL be aware of and handling encryption directly. Of note in the article is how much they bypass the host OS for things like disk read-cache etc.

Full disk encryption isn't sufficient for complience (at least pci) as you need to encrypt the sensitive data in use also and manage the keys in a very specific manner.

FDE won't even work for data at rest unless you can do split keys and auditing.

This isn't about security this is about complience.