Tag Archives: encryption

Do I have a Database Master Key in a database? #SQLNewBlogger

Posted on January 13, 2017 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How can I tell if I have a Database Master Key in a database? It’s actually easy. I query … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Do I have a Database Master Key in a database? #SQLNewBlogger

Checking Permissions for Keys–#SQLNewBlogger

Posted on December 29, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I got a call from someone wanted to check how permissions were stored for encryption objects. I ran a … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking Permissions for Keys–#SQLNewBlogger

Post TDE–Getting Unencrypted Backups

Posted on December 28, 2016 by way0utwest

I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup. This doesn’t seem like that should be an issue, but it can be. A little testing shows how. Let’s assume … Continue reading →

Posted in Blog | Tagged , , , | 2 Comments

Encryption Keys Matter

Posted on September 13, 2016 by way0utwest

Perhaps the importance of protecting encryption keys is even greater than we realize. It appears that the NSA and the US Government have been able to read encrypted traffic for some time on the Internet, perhaps for most of the last … Continue reading →

Posted in Editorial | Tagged , | 4 Comments