Discover how to read the properties of a specific SQL Server certificate using its certificate_id and the built-in CERTPROPERTY function.
Discover how CERT_ID can be used to conditionally execute statements (like a drop or create) based on the existence of a specific certificate, since it returns a noon-NULL value only if the certificate exists.
Do you know how to restore certificates in SQL Server? Read on to find out how, even though there is no RESTORE CERTIFICATE statement.
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.
Certificates are an important part of you encryption strategy and as such need to be backed up. Discover how to achieve that, by using the BACKUP CERTIFICATE statement.