The Importance of Always Encrypted Columns in SQL Servers

If you design something from the get-go and make sure that your developers understand the implications of always encrypted, the benefits are huge. Even if an attacker could actually get into the memory space of SQL server, they can't get the data because the keys aren't there. In the case of SGX and VBS, the keys are held somewhere else where the attacker has no access due to virtualization. It's an incredible defense, but you have to design around it correctly.