As far as I'm aware if you need to hide data from everyone, including SA/Sysadmins then there's only 1 real option.
Always Encrypted (Microsoft Learn | SQL)
Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national/regional identification numbers (for example, U.S. social security numbers), stored in Azure SQL Database, Azure SQL Managed Instance, and SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the Database Engine. This provides a separation between those who own the data and can view it, and those who manage the data but should have no access - on-premises database administrators, cloud database operators, or other high-privileged unauthorized users. As a result, Always Encrypted enables customers to confidently store their sensitive data in the cloud, and to reduce the likelihood of data theft by malicious insiders.
The thing that makes it unique is that you need a certificate + permissions on the SQL to be able to see the database, so just having admin rights on the SQL Server will not be enough to view the data.
It has a lot of downsides and limitations that you need to double check if they work for you.
The list is a bit too long to go over here and also depends if you want to use Randomized or Deterministic encryption.
I'd personally stay away from this unless encryption is of the highest importance, due to the many downsides, but it does provide what you need.