October 2008 - Posts

• TDE: Under The Hood With Database Encryption Key

  Posted Friday, October 31, 2008 10:21 AM | 0 Comments
  
  

  There is a scene in the 1955 Looney Tunes short called "Sahara Hare" in which Yosemite Sam is attempting to enter a castle in the desert. After various failed methods of forced entry he encounters a secret entrance in the wall of the castle. Read More by Johnm | 0 Comments | Comment on this post

• TDE: Under The Hood With Master Key

  Posted Thursday, October 23, 2008 5:32 AM | 0 Comments
  
  

  Recently at an IndyPASS meeting I facilitated a general question and answer session preceding our regularly scheduled feature presentation for the month. There was a lot of great questions covering many aspects of SQL Server; but I was most excited to Read More by Johnm | 0 Comments | Comment on this post

• Releasing the Pigeons

  Posted Wednesday, October 15, 2008 5:55 AM | 1 Comments
  
  

  I receive a daily feed from http://datalossdb.org/latest_incidents.rss which provides very basic information in regard to data loss events. These data loss events are not situations where a database crashes and data is lost, these are events in which Read More by Johnm | 1 Comments | Comment on this post

• Encryption Alternatives

  Posted Friday, October 10, 2008 8:24 AM | 4 Comments
  
  

  Databases often contain sensitive information and cell-level encryption is a very effective method to protect this information from those who should not have access to it. Although, encryption is not without its challenges. There is a performance cost. Read More by Johnm | 4 Comments | Comment on this post

• Understanding Master Keys

  Posted Friday, October 03, 2008 9:57 AM | 0 Comments
  
  

  At the heart of encryption are keys. These allow you, the authorized user, to unlock the subsequent key in a key hierarchy or the cipher text contained within a database. This hierarchical relationship in SQL Server 2008 is illustrated at http://msdn.microsoft.com/en-us/library/ms189586.aspx. Read More by Johnm | 0 Comments | Comment on this post