Tag Archives: encryption

Secure Enclave Concerns

We worry about security as data professionals. It’s a constant issue, though it seems that so many of the data breach issues come from simple mistakes. We have lots of automation, configuration as code, and more. These days we should … Continue reading

Posted in Editorial | Tagged , | 1 Comment

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 , , , , | Comments Off on Restoring an Expired Certificate–#SQLNewBlogger

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 , , | Comments Off on High Prices for High Security