Category: DMVs & CVs

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

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

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

• sys.certificates: How to get Information about all Certificates in a Database

  

  2014-05-04 - Cryptography, DMVs & CVs, General, Security

  sys.certificates: Find out where to turn when you need information like the name the X.509 subject or the last backup date of a certificate that is installed in the current database.

  [more…]

• LOGINPROPERTY – Getting to know your SQL Logins even more

  

  2014-04-07 - DMVs & CVs, General, Security, Security

  LOGINPROPERTY is a SQL Server catalog function that can be used to query a total of twelve properties for SQL Logins not even revealed by the sys.sql_logins catalog view. Read on to find out how to use LOGINPROPERTY and which properties it can return.

  [more…]