Tag: asymmetric key

• The sys.asymmetric_keys Catalog View

  

  2014-05-26 - Cryptography, DMVs & CVs, General, Security, Security

  The sys.asymmetric_keys catalog view is a one-stop shop to get information about the asymmetric keys in the current database. Read on to discover how to use it.

  [more…]

• CREATE ASYMMETRIC KEY – How to Generate an Asymmetric Key

  

  2014-05-23 - Cryptography, Encryption Hierarchy, General, Security, Series

  What is the difference between certificates and asymmetric keys in SQL Server and how do you generate asymmetric keys in T-SQL? Read on to get all the details.

  [more…]

• The SQL Server Encryption Hierarchy

  

  2014-04-20 - Cryptography, Encryption Hierarchy, General, Security, Series

  Discover how in SQL Server the different encryption keys can build a complex encryption hierarchy in which one key protects the next.

  [more…]

• Asymmetric Key Encryption

  

  2014-03-24 - Cryptographic Terminology, Cryptography, General, Security, Series

  Asymmetric key encryption (aka public-key encryption) works with two separate keys, a public key to encrypt and a private key to decrypt. Read on to see the advantages and disadvantages of this type of encryption.

  [more…]