RE: encrypt sensitive data

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 03/24/05

  • Next message: Uri Dimant: "Re: substring update?" 
    Date: Thu, 24 Mar 2005 01:15:02 -0800

    Hi

    Do it at application level using the Windows API's of if you use .NET, use
    the Crypto classes.

    SQL server 2005 will support encryption at row level.

    Regards
    Mike

    "Hassan" wrote:

    > How do you encrypt sensitive data that may be stored in a database such as
    > passwords, creditcard numbers,etc.. ?
    >
    > 3rd party tools ? Internal ..If so how.. ? Does decrypting add latency ..
    > Any info that you can provide would be valuable. Using SQL 2000
    >
    >
    >

  • Next message: Uri Dimant: "Re: substring update?"

    Relevant Pages

    • Re: locking
      ... escalates to a page level lock from a row level. ... SQL Server MVP ... Default is row level, but optimizer may escalate it to page ...
      (microsoft.public.sqlserver.server)
    • Re: Row level and column level permissions.
      ... "Arun" wrote in message ... column level permissions in an SQL server database. ... i could find some recommendations for implementing row level permissions.(I ... be applicable for my reporting tool(either crystal or sql reporting ...
      (microsoft.public.sqlserver.server)
    • Re: Evaluating Xml vs. One field per row in vertical app
      ... Did you take a look at some the SQL Server 2005 XML whitepapers on MSDN? ... Note that in SQL Server 2005 the granularity is still at the row level and ...
      (microsoft.public.sqlserver.xml)
    • Re: How does locking work in MSDE
      ... Exactly the same as in SQL Server. ... Locks are applied at the row level but ... MSDE Manager SQL Tools ... "Chris Bruyere" wrote in message ...
      (microsoft.public.sqlserver.msde)
    • Re: Encription of a column
      ... SQL Server 2000 does not natively support in-database cryptographic ... support encryption and key management. ...
      (microsoft.public.sqlserver.security)