Category: Encryption Hierarchy

• How to Create a Symmetric Key

  

  2014-06-14 - Cryptography, Encryption Hierarchy, General, Security, Series

  Encrypting large amounts of data in SQL Server should be done with symmetric key encryption. Discover how to create the necessary key for this encryption type.

  [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…]

• CREATE CERTIFICATE – How to create a Self-Signed Certificate in SQL Server

  

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

  Discover how the CREATE CERTIFICATE T-SQL statement can be used to create a self-signed certificate, and what your options are to protect its private key.

  [more…]

• How to Create a Database Master Key

  

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

  Discover how to create and protect the Database Master Key that builds the base of a database encryption hierarchy and in turn can protect certificates and asymmetric keys in its database.

  [more…]

• How to Create a Service Master Key in SQL Server

  

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

  Discover how the service master key is created, what it protects and how it is protected itself, and learn about the two important security implications that arise from the protection mechanism used.

  [more…]