http://sqlblog.com/blogs/michael_coles/archive/tags/algorithms/default.aspxTags: algorithmsenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspxFri, 29 Jan 2010 16:52:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:21600Mike C4http://sqlblog.com/blogs/michael_coles/comments/21600.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=21600http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=21600A common question on the newsgroups is "how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?" I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=21600" width="1" height="1">SQLprogrammingc sharpencryptionc#SQL Servercertificatesasymmetric keyssecurityalgorithmsSQL 2008scriptsdatabasesql 2005stored procedureshttp://sqlblog.com/blogs/michael_coles/archive/2009/07/12/hacking-social-security-numbers.aspxMon, 13 Jul 2009 00:09:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:15230Mike C6http://sqlblog.com/blogs/michael_coles/comments/15230.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=15230http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=15230According to this paper from the Proceedings of the National Academy of the Sciences (PNAS), social security numbers (SSNs) are pretty easy for hackers, identity thieves, and other miscreants to predict based on publicly available data. I found this interesting...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2009/07/12/hacking-social-security-numbers.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=15230" width="1" height="1">programmingstatisticssecuritysocial security numberssnssaalgorithms