Tag Archives: encryption

Backwards Compatible Symmetric Keys in SQL Server 2017+

I discovered recently that there was a change made in SQL Server 2017 to the way that symmetric key passphrases are hashed. There’s a KB article that notes the fix, but basically the passphrases used to be encrypted with SHA1. … Continue reading

Posted in Blog | Tagged , | 2 Comments

Restoring an Expired Certificate–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One common task that you might need to handle if you work with encryption is dealing with a certificate. … Continue reading

Posted in Blog | Tagged , , , ,

High Prices for High Security

I was excited to see the new Secure Enclave technology come to Always Encrypted (AE) in SQL Server 2019. I’ve thought that the way Microsoft implemented the AE technology in SQL Server 2016 was a start and a good step … Continue reading

Posted in Editorial | Tagged , ,

High Security Prices–Always Encrypted 2019 needs Datacenter Edition

I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and then encountered this issue: After embarrassing myself to other MVPs and … Continue reading

Posted in Blog | Tagged , , | 1 Comment