Category: General

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

• The Missing BACKUP ASYMMETRIC KEY statement

  

  2014-06-02 - Backup, General, Security

  Is the BACKUP ASYMMETRIC KEY statement really missing from the T-SQL language? Read on to discover the truth and see if there are any viable alternatives.

  [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 Secret of the Database Boot Page

  

  2014-05-28 - General, Series, SQL Server Internals, Storage Wednesday

  The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.

  [more…]