Post reply

Data Encryption Options for Image Data Type ?

  • April 5, 2010 at 6:19 am

    #213477

    We have a need to encrypt voice recordings that are stored as "image" data in a column in a SQL 2005 table. What would you suggest to accomplish this ? Are the SQL built-in tools applicable, or is a 3rd party tool required ?

    The data is about 1 terabyte total (150,000,000 rows), with about 80,000 rows being added daily.

    A subset of these records need to be listened to daily (thus unencrypted) to verify the information.

    Thanks in advance.

  • April 5, 2010 at 7:39 am

    #1145707

    So far as I know, SQL 2005 doesn't do built-in encryption on image data types. I could be wrong, but I don't think it does.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • April 5, 2010 at 8:01 am

    #1145730

    Any recommendations of a 3rd party tool ?

  • April 5, 2010 at 4:59 pm

    #1146101

    Here is some info that may be of use.

    http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1118005,00.html?bucket=ETA&topic=301323

    I have never done it before, but it looks like you can do it with the built in SQL 2005 stuff. There is also the blowfish stuff that could help.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply