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.
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.
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.
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.
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.