<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://sqlblog.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Michael Coles: Sergeant SQL : security, SQL 2008</title><link>http://sqlblog.com/blogs/michael_coles/archive/tags/security/SQL+2008/default.aspx</link><description>Tags: security, SQL 2008</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>Encrypt it in .NET/Decrypt it on SQL Server?</title><link>http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspx</link><pubDate>Fri, 29 Jan 2010 16:52:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:21600</guid><dc:creator>Mike C</dc:creator><slash:comments>4</slash:comments><comments>http://sqlblog.com/blogs/michael_coles/comments/21600.aspx</comments><wfw:commentRss>http://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=21600</wfw:commentRss><wfw:comment>http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=21600</wfw:comment><description>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...(&lt;a href="http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://sqlblog.com/aggbug.aspx?PostID=21600" width="1" height="1"&gt;</description><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/algorithms/default.aspx">algorithms</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/asymmetric+keys/default.aspx">asymmetric keys</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/c+sharp/default.aspx">c sharp</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/c_2300_/default.aspx">c#</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/certificates/default.aspx">certificates</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/database/default.aspx">database</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/encryption/default.aspx">encryption</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/programming/default.aspx">programming</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/scripts/default.aspx">scripts</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/security/default.aspx">security</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/SQL/default.aspx">SQL</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/sql+2005/default.aspx">sql 2005</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/SQL+2008/default.aspx">SQL 2008</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/SQL+Server/default.aspx">SQL Server</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/stored+procedures/default.aspx">stored procedures</category></item><item><title>SQL 2008 Encryption EKM Virtual Event</title><link>http://sqlblog.com/blogs/michael_coles/archive/2009/12/10/sql-2008-encryption-ekm-virtual-event.aspx</link><pubDate>Thu, 10 Dec 2009 18:50:00 GMT</pubDate><guid isPermaLink="false">21093a07-8b3d-42db-8cbf-3350fcbf5496:19747</guid><dc:creator>Mike C</dc:creator><slash:comments>0</slash:comments><comments>http://sqlblog.com/blogs/michael_coles/comments/19747.aspx</comments><wfw:commentRss>http://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=19747</wfw:commentRss><wfw:comment>http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=19747</wfw:comment><description>I'll be presenting at a SafeNet -sponsored virtual event on Dec. 15. The topic is "SQL 2008 Encryption EKM Scenarios". We'll be discussing the practical applications of EKM in SQL Server 2008, and the most common scenarios that require EKM functionality....(&lt;a href="http://sqlblog.com/blogs/michael_coles/archive/2009/12/10/sql-2008-encryption-ekm-virtual-event.aspx"&gt;read more&lt;/a&gt;)&lt;img src="http://sqlblog.com/aggbug.aspx?PostID=19747" width="1" height="1"&gt;</description><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/ekm/default.aspx">ekm</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/encryption/default.aspx">encryption</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/presentation/default.aspx">presentation</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/security/default.aspx">security</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/SQL+2008/default.aspx">SQL 2008</category><category domain="http://sqlblog.com/blogs/michael_coles/archive/tags/SQL+Server+2008/default.aspx">SQL Server 2008</category></item></channel></rss>