Forum Replies Created

Viewing 15 posts - 8,311 through 8,325 (of 39,771 total)

  • RE: Track Your Consultants

    Eric M Russell (3/29/2016)


    Where does optional SSL encryption fit into this picture? Does anyone here use this?

    https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

    I've done this in testing with a self signed certificate. We did this years...

  • RE: Protecting sa

    Jeff Moden (3/28/2016)


    Steve Jones - SSC Editor (3/28/2016)


    sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try...

  • RE: Protecting sa

    Ed Wagner (3/28/2016)


    Steve Jones - SSC Editor (3/28/2016)


    sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try...

  • RE: Row Level Security Updates

    TomThomson (3/28/2016)


    Nice question,

    It's very like the question 11 days go. Are you trying to din this into us by repetition? (If so, good on you!)

    More just trying to...

  • RE: Protecting sa

    sa can't be locked out, so it's susceptible to brute force. If you run mixed mode, you do need network controls to try and prevent constant attacks.

  • RE: SPSS .SAV File - How to open from SQL Server

    There is this: http://www.officereports.com/spss-survey-reporter-alternative

    However, I don't know of any free software for this. Likely you will need to buy some license to work with these files.

    NOTE: We do not condone...

  • RE: Row Level Security Updates

    yes, sorry. Typo corrected. That's what I get for trying to type code in here instead of copy/paste.

  • RE: Emails alerts for a topic

    When you reply (or start) a topic, there is a drop down below the edit box. This has the subscription type.

    By default it is set for immediate notification. If you...

  • RE: Dexterity Matters

    Iwas Bornready (3/28/2016)


    Good subject today. I agree on the input errors and especially coding for them. Limit input to what is acceptable and allow for easier cleanup when even that...

  • RE: Dexterity Matters

    david.gugg (3/28/2016)


    Anyone else here have problems with accidentally IMing their passwords out to coworkers? It's so easy to think you are in one application, but instead you have Lync...

  • RE: More GROUP BY

    Andy Hogg (3/25/2016)


    Hi Steve, am I misreading this?

    The correct answer is recognised as:-

    GROUP BY Person HAVING COUNT(DISTINCT Played) = 3

    I agree with that.

    But then in the subsequent explanation, one of...

  • RE: Protecting sa

    ZZartin (3/25/2016)


    Hmm... a good password on the sa account should sufficient, I wouldn't want to disable it in the event it's actually needed. And I certainly wouldn't want to...

  • RE: Protecting sa

    Tony Lanterman (3/25/2016)


    In our environment (several hundred SQL instances geographically dispersed around North America) we were required to randomize the SA password by audit long ago. We have a...

  • RE: Protecting sa

    DBA_Rob (3/25/2016)


    Yes we do set a password before we disable it. As you point out we have had to enable it for 3rd party applications to be installed. ...

  • RE: Protecting sa

    DBA_Rob (3/25/2016)


    I can't think of a SQL Server environment where I didn't end up needing to turn on mixed authentication, but when it comes to the sa account I usually...

Viewing 15 posts - 8,311 through 8,325 (of 39,771 total)