I run a client-server application and I am setting up a SQL Server 2008 R2 database with encryption. I am wondering if someone can give me the plus and minus of creating a certificate with a password versus creating one where the master key is used.
CREATE CERTIFICATE MY_Cert ENCRYPTION BY PASSWORD = 'MyPassword' WITH SUBJECT = 'MySubject';
CREATE CERTIFICATE MY_Cert ENCRYPTION WITH SUBJECT = 'MySubject';
What is the consensus up and down side when encrypting and decrypting?