Security - SQL 2005 - New features
Today we discussed the updated Authorization Model, then enhanced Authentication model (using Certificates), how easy it is to encrypt and decrypt data at the field level. The new Database Schema model and a few examples of how to use it. I know a rna few mintutes over again, but I thought the topic was pretty important and even at a high-level still takes a bit to discuss fully.
here is the sample code, play with it a bit and come back with additional questions - there is abunch I didn't cover so as you start to apply this technology you will most likely run into a few stopping points - feel free to ask.
Steve
http://www.neudesic.com/uploads/Steve_Muise/05_Security.zip