Category: Series

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

• The Shared Global Allocation Map (SGAM)

  

  2014-04-23 - General, Series, SQL Server Internals, Storage Wednesday

  Discover how SQL Server tracks mixed extents containing free pages using a Shared Global Allocation Map made up of one SGAM page per GAM Interval.

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