Forum Replies Created

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

  • 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...

    Tom

    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...

    Tom

    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 ...

    Tom

    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

    Tom

    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...

    Tom

    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...

    Tom

    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...

    Tom

    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...

    Tom

    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...

    Tom

    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...

    Tom

    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...

    Tom

    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

    Tom

    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...

    Tom

    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...

    Tom

    July 15, 2014 at 10:03 pm

    #1729711

  • RE: Is a Primary Key an index?

    Irritating because over-pedantic. Good question nevertheless.

    Tom

    July 15, 2014 at 9:17 pm

    #1729706

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