I have a classic question (probably for most of you), as I am new to dba. Why do we use certificate or asymmetric types of login?
As far as I know, Windows and SQL server authenticated logins will do fine jobs. In what scenario does one use certificate or asymmetric logins? I can only see one benefit that you can set specific expiry date for certificate logins, but other than that i can not see anything significant. So based on that, why do we need them?
Please your advise, correct me if I am wrong. Thanks.