Tag: SQL Server

• B+Trees – How SQL Server Indexes are Stored on Disk

  

  2014-06-18 - General, Series, SQL Server Internals, Storage Wednesday

  How does SQL Server organize clustered and non-clustered indexes on disk? SQL server uses B+Trees. Read on to find out what B+Trees are and how they are implemented in SQL Server.

  [more…]

• The sys.symmetric_keys Catalog View

  

  2014-06-16 - Cryptography, DMVs & CVs, General, Security, Security

  Where do you turn if you need information about the symmetric keys in the current database? Meet the sys.symmetric_keys catalog view and discover what types of information on symmetric keys it can provide.

  [more…]

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

• The Server Configuration Page

  

  2014-06-11 - DMVs & CVs, General, Series, SQL Server Internals, Storage Wednesday

  The Server Configuration Page is the place where SQL Server stores its configuration values (sp_configure). It is of a special page type that is found only once per SQL Server instance. Read on to get all the details.

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