YOUR CHANNEL IS LOADING

LATEST EPISODES MORE EPISODES

  • 1

    Trusting Systems

  • 2

    Understanding HA

  • 3

    How do you solve T-SQL problems?

  • 4

    Morphing Microsoft

  • 5

    The Control Poll

The Voice of the DBA Encryption in Production

MEVIOtoday

Feb 09, 2012 Encryption in Production

The encryption capabilities of SQL Server have been growing in each new version. We have gone from password protected backups to Transparent Data Encryption (TDE), we have moved form PWDENCRYPT() to symmetric, asymmetric keys, and certificates. There are quite a few options available in the current SQL Server platform. However I don't often see people writing or talking about their use of security.

It might be the nature of sensitive data means keeping the use of encryption quiet, but that shouldn't matter. If you are keeping your keys safe, the algorithms and deployments you use should not matter. This Friday I wanted to ask a question about your use of encryption in real world systems.

 

Read the rest of "Encryption in Production" at SQLServerCentral.