Tag Archives: encryption

Encryption Libraries

One of the ways we work to implement better security is through the use of encryption. I remember the early days of PGP, VPNs adding end to end encryption, IPSec becoming available, and more. I was excited to see column … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

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 , , , ,