Tag: SQL Server

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

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