The intent of this feature is to prevent someone from stealing your backup files or .mdf/.ldf files and restoring them on another server.Your other option is cell-level encryption, which can be accomplished by individually encrypting each column; but your data types for your columns will need to be varbinary.