Michael Coles: Sergeant SQL : SQL 2008, encryption, SQL Server 2008

T-SQL Tuesday #004: Why Doesn't TDE Encrypt My FILESTREAM Data?

Mike C — Tue, 09 Mar 2010 02:42:00 GMT

This post is my entry for Adam Machanic's T-SQL Tuesday #004 , hosted this time by Mike Walsh . I was at the RSA Conference in San Francisco last week discussing database encryption options in SQL Server 2008 and one question seemed to keep coming up....(read more)

SSIS: Mo' Secure Configurations

Mike C — Mon, 18 Jan 2010 22:19:00 GMT

I ran into an issue the other day and I needed a solution for automically configuring my SSIS packages from securely stored DBMS connection strings. Problem is that most DBMSs don’t support Integrated Authentication—they require a username and password....(read more)

SQL 2008 Encryption EKM Virtual Event

Mike C — Thu, 10 Dec 2009 18:50:00 GMT

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....(read more)