Taking advantages of Cryptographic features in SQL 2005 - security
When I had a chance to know about encryption features in SQL Server I always go with books online as a first hand information, but there is more to ask about this feature in 2005 version:
Have you ever thought about encryption in SQL Server, how to implement it?
What you need to know to implement cryptographic elements in SQL Server?
Assign certificates for effective security in executing sensitive compilations within the SQL Server engine?
How the Data is encypted in SQL Server?
Symmetric keys existence in SQL Server 2005?
Well, many questions when you get a thought or requirement in terms of encrypting the data. But I have no worry to know about the features and knowledge you need to have for encryption blurb in SQL Server.
Laurentiu's Cryptographic blog series is a good resource in this regard
BOL entry about encryption
Usage of Counter-signatures within stored procedures
Raul-Gracia's blog on digital signatures
Digital-Signature modules in SQL Server
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.