Browse by Tags

Tagged Content List
  • Blog Post: Should All Data Be Encrypted By Default?

    Recently several IT industry information outlets have reported that there has been a 10-year concentrated, organized effort on breaking through computer security at some of the largest companies in the world. Government sites have also been attacked in multiple countries. Add to this the regular loss...
  • Blog Post: Windows Azure Security Review

    Current as of 08/01/2011 - Check the Resources listed below for more up-to-date information on this topic Background: Security for any computing platform involves three primary areas: Principals (users or programmatic access to an asset or other program) Securables (objects, data or programs that can...
  • Blog Post: Have You Backed Up Your Database Master Key?

    If you have encrypted columns in a database or certificates used to create them, you need to make sure that you back up the Database Master Key as part of your maintenance, and then protect that backup file. Here's the short version of the command: BACKUP MASTER KEY TO FILE = '<complete path and filename>...
  • Blog Post: Backup those Keys

    I'm working on a Policy that will expose a particularly thorny issue. In SQL Server 2008, you can use a new feature called Transparent Data Encryption (TDE). This feature encrypts the entire database, so you don't have to change your application at all. If anyone were to steal the database, they couldn...
  • Blog Post: The Importance of Connections

    Since I didn't blog about anything very technical in my last entry, I thought I would post a little something about what we're hearing about the "Connection" dialogs. We have quite a few places in Management Studio that we pop up a place for you to connect to a Database Engine, Reporting Server or analysis...
  • Blog Post: Speeding up encryption

    A friend of mine from Tampa, Florida wrote me the other day with an interesting observation: "I have a small finding and don't know where to publish it. Maybe you can help get the word out via your blog? OPEN SYMMETRIC KEY is somewhat costly to execute. Since keys will remain open unless explicitly...
Page 1 of 1 (6 items)