Category: Cryptography

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

• How to Back Up the Database Master Key

  

  2014-06-09 - Backup, Cryptography, General, Security

  The Database Master Key is often required to access any encrypted data in a SQL Server database. Therefore, it is important to always have a good backup of this important asset. Learn how to use the BACKUP MASTER KEY statement to backup this master key.

  [more…]

• How to Back Up the Service Master Key

  

  2014-06-06 - Backup, Cryptography, General, Security

  In SQL Server the Service Master Key is probably the most important encryption entity. Because of that, it needs to be protected and backed up. Read on to discover how to take a backup of this key encryption key.

  [more…]

• Creating an Asymmetric Key using a Strong Name File

  

  2014-05-30 - Cryptography, General, Security

  .NET Strong name files are built to hold a single asymmetric key pair. Read on to discover how to generate SQL Server asymmetric keys form strong name files.

  [more…]

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