May 28, 2009 11:00 AM
Posted by: Denny Cherry
Database,
Database security,
Encryption,
Hashing,
Security,
SecurityFightClubThe biggest difference between encrypted data and hashed data is that encrypted data can be decrypted later. Hash algorithms such as MD5 are one way hashing algorithms which means that the value that is returned can't be decrypted back to the original value.
It is important to know the...
August 4, 2008 11:00 AM
Posted by: Denny Cherry
Config,
Encryption,
IPSec,
OpenSSL,
PGP,
Secure Data Transfer,
Secure FTP,
SFTP,
SQLYou've got a few options, none of which are all that easy to setup.
1. Export the data, then encrypt the file, then transfer the file, then decrypt the file, then import the file.
2. Setup IPSec between the two SQL Servers and then transfer the data as normal.
3. Setup a Secure FTP Server at...
July 10, 2008 11:00 AM
Posted by: Denny Cherry
C#,
CREATE ASSEMBLY,
CREATE PROCEDURE,
Encryption,
Microsoft.SqlServer.Server,
SQL CLR Procedure,
SQL Server 2005,
SQL Server stored procedures,
T/SQLA little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005. Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL. Could I have done what I needed to without a CRL...
May 22, 2008 3:37 PM
Posted by: Denny Cherry
Billy Crystal,
Cache,
CLARiiON,
EMC,
EMC World 2008,
EncryptionWednesday at EMC World was a session packed day to be sure.
I started my morning with CLARiiON Rebuild Settings and Data which was an in depth look at how exactly the CLARiiON systems handle rebuilds, and how long various rebuilds take. In addition we went into detail as to how the CLARiiON...
April 17, 2008 8:00 AM
Posted by: Denny Cherry
Compliance,
DataManagement,
Encryption,
SQL Server 2008While I think that the one click database encryption that Microsoft has built into SQL Server 2008 is a good idea, but I'm not sure how useful it actually is. It's touted as giving you data encryption of the entire database without any code change.
What this actually means is that if someone...
