Forum Replies Created

Viewing 15 posts - 2,431 through 2,445 (of 7,484 total)

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/17/2014)

    I recreated and opened the key. It decrypts from the same session but when I go to another session it list null.

    Every time you create a key, you...

    July 18, 2014 at 4:24 am

    #1730539

  • RE: Encrypt SSN Example (TDE)

    Ed Wagner (7/16/2014)

    The encryption part stands alone. Once you have it working and understand it, then add in the other parts you need in your solution. This is...

    July 18, 2014 at 4:12 am

    #1730536

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/16/2014)

    I need to add to a Data Transformation task to Load to Staging.

    I need o update the existing record to the encrypted value so I need to add...

    July 18, 2014 at 4:06 am

    #1730534

  • RE: Is a Primary Key an index?

    Phil Factor (7/17/2014)

    @Sergei

    Please correct me if I'm wrong but I'd always believed a primary key was enforced by a constraint which was implemented by means of both a UNIQUE ...

    July 18, 2014 at 3:58 am

    #1730532

  • RE: Today's Random Word!

    SQLRNNR (7/16/2014)

    Ed Wagner (7/16/2014)

    TomThomson (7/16/2014)

    BWFC (7/16/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    Revenant (7/14/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    BWFC (7/11/2014)

    Venus

    desire

    Want

    Wanton

    Pork

    Launch 😀

    Dinghy

    wherry

    Row

    Tuple

    Sequence

    July 16, 2014 at 9:54 am

    #1729914

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (7/16/2014)

    TomThomson (7/16/2014)

    Steve Jones - SSC Editor (7/16/2014)

    GilaMonster (7/16/2014)

    Jeff Moden (7/15/2014)

    To be honest, I'm glad this person is taking such caution and has such FUD about it.

    I would...

    July 16, 2014 at 9:47 am

    #1729909

  • RE: Are the posted questions getting worse?

    Jack Corbett (7/16/2014)

    Steve Jones - SSC Editor (7/16/2014)

    GilaMonster (7/16/2014)

    Jeff Moden (7/15/2014)

    To be honest, I'm glad this person is taking such caution and has such FUD about it.

    I...

    July 16, 2014 at 9:38 am

    #1729905

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/16/2014)

    GilaMonster (7/16/2014)

    Jeff Moden (7/15/2014)

    To be honest, I'm glad this person is taking such caution and has such FUD about it.

    I would be, if he...

    July 16, 2014 at 8:59 am

    #1729890

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/16/2014)

    I can't get it to store the encrypted value.

    I seem to have missed something out in the decryption. If you change

    SELECT CONVERT(varchar(128), DecryptByKey(SSN)) as Plaintext_SSN

    FROM...

    July 16, 2014 at 8:44 am

    #1729880

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/16/2014)

    Tom, thank you very much for your help.

    If you were to execute the code that I posted you will find that it does not not store a value...

    July 16, 2014 at 8:18 am

    #1729868

  • RE: Encrypt SSN Example (TDE)

    Welsh Corgi (7/16/2014)

    I was able to Insert the Record.

    What do I need do to read the unencrypted value?

    Read and decrypt. The last part of the example gives you...

    July 16, 2014 at 7:54 am

    #1729850

  • RE: Is a Primary Key an index?

    Phil Factor (7/16/2014)

    Regarding this

    ... default candidate key to be used to select particular rows of the table

    Can anyone expand on what is meant by 'default' here?

    In addition to what's been...

    July 16, 2014 at 6:51 am

    #1729823

  • RE: Today's Random Word!

    BWFC (7/16/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    Revenant (7/14/2014)

    Ed Wagner (7/14/2014)

    SQLRNNR (7/14/2014)

    BWFC (7/11/2014)

    Venus

    desire

    Want

    Wanton

    Pork

    Launch 😀

    Dinghy

    wherry

    July 16, 2014 at 6:32 am

    #1729817

  • RE: Are the posted questions getting worse?

    GilaMonster (7/15/2014)

    Jeff Moden (7/15/2014)

    Lynn Pettis (7/15/2014)

    OMG, how can someone who has been working with SQL Server for over 9 years still behave like an entry level DBA/Developer??

    Whose turn with the...

    July 15, 2014 at 10:09 pm

    #1729712

  • RE: Encrypt SSN Example (TDE)

    OK, here is the really really simple guide to how to do it:-

    First create a certificate, access to which represents permission to decrypt the SSN column; lets call it SSN_Cert.

    Then...

    July 15, 2014 at 10:03 pm

    #1729711

Viewing 15 posts - 2,431 through 2,445 (of 7,484 total)