Very good code compilation!  I have just started into this subject recently with lots of things still to learn and understand.  I am sorry for my ignorance, but I want to ask a couple of dumb questions

Would I encrypt all of my data? and if I do, then how does data that gets returned get encrypted/decrypted through this process?  I am probably missing something obvious - any further discussion on problem - solution examples would be really good for me who "thinks" I understand the basics of SQL Server.