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.