Tag Archives: encryption

Backwards Compatible Symmetric Keys in SQL Server 2017+

Posted on December 23, 2019 by

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

Posted on September 2, 2019 by

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

Posted on May 30, 2019 by

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

Posted on May 30, 2019 by

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