Encryption in SQL Server is tricky to put into practice and control, but it's staying needed more and more generally. I really like this PowerShell library for DBAs. in lieu of generate a lot about it listed here, https://www.ralantech.com/sql-health-check-consulting-service/