Forum Replies Created

Viewing 15 posts - 8,146 through 8,160 (of 39,771 total)

  • RE: Specialist or Generalist

    ccd3000 (4/26/2016)


    I would suggest being something of generalist in your early career so that you can intellectually sample what's out there and see what you like or at least what...

  • RE: Storing encypted SSN's

    Eric M Russell (4/26/2016)


    Post the SHA2_256 hash of any validly formatted plaintext SSN (ie: any code conforming to 999-99-9999), and I'll reply back with the un-hashed plaintext SSN number.

    For example...

  • RE: Specialist or Generalist

    Alan.B (4/26/2016)


    Great Editorial Steve!

    Thanks

  • RE: Storing encypted SSN's

    Steve Jones - SSC Editor (4/26/2016)


    GilaMonster (4/26/2016)


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

  • RE: Storing encypted SSN's

    GilaMonster (4/26/2016)


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

  • RE: Are the posted questions getting worse?

    rodjkidd (4/26/2016)


    TomThomson (4/26/2016)


    Steve Jones - SSC Editor (4/26/2016)


    See you there, and...

    you have a car? I thought everyone in the UK just used trains.

    Trains? UK rail fares are by far...

  • RE: A Call for Articles

    Very true, and it's on the list. I just logged a ticket for generic code (PoSh, Python, etc)

    formatting in the drop down.

  • RE: Are the posted questions getting worse?

    GilaMonster (4/26/2016)


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

  • RE: Are the posted questions getting worse?

    rodjkidd (4/26/2016)


    Oh this time next week I should be in Liverpool...

    Rodders...

    See you there, and...

    you have a car? I thought everyone in the UK just used trains.

  • RE: db_backupoperator can't back up database

    wow, deny to public. That would have been low, low on my list.

    Good catch, Brandie.

    I hate anyone that adds any permissions to public. Please, please, don't do that ever. Add...

  • RE: The Pen Test

    Vendors won't, at least not until RFCs start to require some proof of testing. That won't happen until insurance companies put it in policies with companies.

  • RE: Who's going to SQL Bits in Liverpool?

    BWFC (4/26/2016)


    I'm now unregistered as yesterday I was officially invited to spend my Saturday afternoon with an army of four-year-olds on a sugar-rush. Although looking at pictures of SQLBits...

  • RE: Sum with Isnull

    Phil Parkin (4/26/2016)


    As a general rule, it's better to put IsNulls inside Sums rather than outside. This avoids the warning message about NULL values being eliminated:

    Select Sum(IsNull([Col],0))

    +1. Agree with Phil.

  • RE: SQL Server monitoring tools

    I'm mostly with Grant (same employeR), but I'd put the MS tool lower. PErhaps I'm wrong as I haven't used it in awhile, but it's more setup hassle, and admin...

  • RE: db_backupoperator can't back up database

    Log

    user_name()

    suser_sname()

    etc. (there are a few more)

    into a table before the app runs the command (and the command). Check there isn't any impersonation.

    If you execute as user = 'login', can...

Viewing 15 posts - 8,146 through 8,160 (of 39,771 total)