Browse by Tags

• algorithms
• c sharp
• c#
• certificates
• database
• encryption
• programming
• scripts
• security
• SQL
• sql 2005
• SQL 2008
• SQL Server
• SQL Server 2008
• stored procedures

• Encrypt it in .NET/Decrypt it on SQL Server?

  A 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 Read More... Posted Friday, January 29, 2010 12:52 PM by Mike C | 4 Comments Filed under: algorithms, asymmetric keys, c sharp, c#, certificates, database, encryption, programming, scripts, security, SQL, sql 2005, SQL 2008, SQL Server, stored procedures

• No Backup For Asymmetric Keys

  The encryption features in SQL Server 2005 and 2008 provide the ability to create asymmetric encryption key pairs (RSA public/private key pairs) using the T-SQL CREATE ASYMMETRIC KEY statement. One feature that was left out, however, is the ability to Read More... Posted Friday, July 10, 2009 12:32 PM by Mike C | 2 Comments Filed under: asymmetric keys, certificates, encryption, SQL, SQL Server, SQL Server 2008