Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 49,552 total)

  • RE: Storing encypted SSN's

    Google "salt hash" and "rainbow table" and you'll probably have more to read than you have time for.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 12:45 pm

    #1874761

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/26/2016)

    Can't wait for R2-D2 to reprise his full commitment to the series. Hopefully contract negotiations work out by the next show so he can play a bigger role. 😀

    Maybe...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 12:28 pm

    #1874752

  • RE: Are the posted questions getting worse?

    BLOB_EATER (4/26/2016)

    GilaMonster (4/26/2016)

    SQLRNNR (4/26/2016)

    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 12:14 pm

    #1874743

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/26/2016)

    In December, Rogue One is supposed to be released. That is supposed to be a bridge between Episodes 3 and 4 - sorta. It's a side story about stealing...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 12:00 pm

    #1874739

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/26/2016)

    On the other hand why not try something a little more original?

    Nostalgia, among other things. Reassuring audience that they're returning to the 'classic' Star Wars, not following the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 11:50 am

    #1874734

  • RE: Are the posted questions getting worse?

    SQLRNNR (4/26/2016)

    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 11:41 am

    #1874724

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (4/26/2016)

    Ditto and I'll only make one comment on the film, my opinion is that it was S###t

    😎

    Fixed that for you. 🙂

    I loved it. A lot of other people...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 11:35 am

    #1874717

  • RE: Storing encypted SSN's

    ram302 (4/26/2016)

    I will never need to decrypt the SSN, but I will need to add/remove ones as personnel are hired/terminated.

    In that case, don't look at encryption. Just hash the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 10:28 am

    #1874692

  • RE: SQL Server Memory is Full (Urgent help!)

    Grant Fritchey (4/26/2016)

    GilaMonster (4/26/2016)

    Grant Fritchey (4/26/2016)

    I do not recommend this because it will seriously negatively impact your startup time, but if you really want it to immediately use the memory...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 10:26 am

    #1874691

  • RE: Storing encypted SSN's

    jeff.mason (4/26/2016)

    You would need to wait until RTM, which last I had heard was around June-ish?

    Probably sooner. RC3, which was released on the 15th was described (on the SQL...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 8:03 am

    #1874628

  • RE: Storing encypted SSN's

    ram302 (4/25/2016)

    Alternatively, I've thought of just encrypting the SSN values (MD5), storing these MD5 hashes and doing the lookup by the hash instead.

    MD5 is so weak that a google search...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 7:36 am

    #1874604

  • RE: SQL Server Memory is Full (Urgent help!)

    Grant Fritchey (4/26/2016)

    I do not recommend this because it will seriously negatively impact your startup time, but if you really want it to immediately use the memory you allocate for...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 7:18 am

    #1874588

  • RE: SQL Server Memory is Full (Urgent help!)

    Because it's not designed to. It will increase memory usage as necessary, up to the max allowed.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 7:11 am

    #1874582

  • RE: SQL Server Memory is Full (Urgent help!)

    info.sqldbamail (4/26/2016)

    SQL Server is occupying the RAM which it is set Max, and additionally it is also taking the Memory which is left for Windows, where do i need to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 6:37 am

    #1874555

  • RE: Help me in executing this CASE Statement

    What is this even trying to do?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    April 26, 2016 at 6:22 am

    #1874538

Viewing 15 posts - 3,166 through 3,180 (of 49,552 total)