Category: General

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

• CREATE ASYMMETRIC KEY – How to Generate an Asymmetric Key

  

  2014-05-23 - Cryptography, Encryption Hierarchy, General, Security, Series

  What is the difference between certificates and asymmetric keys in SQL Server and how do you generate asymmetric keys in T-SQL? Read on to get all the details.

  [more…]

• DBCC FILEHEADER: Reading the File Header Page

  

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

  Every SQL Server database file has a dedicated file header page. Read on to discover how to use DBCC FILEHEADER to explore the header of your database files and learn about the one property of file header pages that might just affect your backup and restore strategy.

  [more…]

• CERTPRIVATEKEY: Scripting the Private Key of a Certificate

  

  2014-05-19 - Cryptography, General, Security

  Find out how to convert the private key of a SQL Server certificate into a varbinary value using the built-in CERTPRIVATEKEY function.

  [more…]

• CERTENCODED: How to Script your Certificates

  

  2014-05-16 - Backup, Cryptography, General, Security

  The ability to copy certificates from one database to another is often an important requirement in SQL Server security management. Read on to learn how to do just that effectively.

  [more…]