Andy Yun notes a nice feature in SQL Server 2022:
Using QAT compression for your native SQL Server backups will give you better compression with less CPU overhead, than “legacy” compression. So I get smaller backup files, faster, with less CPU burn. What’s there to not like?
There’s a lot to dig into with this post and a special note on Transparent Data Encryption at the end.