Forum Replies Created

Viewing 15 posts - 241 through 255 (of 645 total)

  • RE: Replace Bad Characters in Table

    Regardless of anything else, when doing string operations of this nature, there are two important best practices to follow:

    • ALWAYS use a binary Collation so that you match the...

    June 28, 2017 at 8:15 am

    #1948553

  • RE: Microsoft SQL Server Utilities and Tools

    Great job putting this list together. It's a bit more detailed than other similar lists I have seen. Can you please add SQL# ( http://www.SQLsharp.com/ ) to your list? Sorry,...

    June 25, 2017 at 9:14 am

    #1948080

  • RE: Stairway to SQLCLR Level 7: Development and Security

    JediSQL - Wednesday, June 21, 2017 12:51 PM

    Solomon,
    I have successfully deployed some SQL CLR for EXTERNAL_ACCESS to allow Web service calls from...

    June 21, 2017 at 3:10 pm

    #1947649

  • RE: Converting User SID Binary to String TSQL

    Steve Jones - SSC Editor - Tuesday, June 6, 2017 9:35 AM

    Did you mean sys.fn_varbintohexstr()?

    Yes, I believe that is what Perry meant,...

    June 6, 2017 at 10:10 am

    #1945656

  • RE: Converting User SID Binary to String TSQL

    There is an undocumented built-in function, SID_BINARY, that does this translation from the SDDL form into the binary form:

    SELECT...

    June 2, 2017 at 9:28 am

    #1945144

  • RE: Why I am Excited about SQL Server on Linux

    loyd.gravitt - Thursday, March 2, 2017 12:50 PM

    I would assume that you can administer a SQL Server instance running on a Linux...

    March 2, 2017 at 12:56 pm

    #1931343

  • RE: Why I am Excited about SQL Server on Linux

    t.ovod-everett - Thursday, March 2, 2017 11:13 AM

    Personally, I think the biggest reason to be excited about SQL Server on Linux is...

    March 2, 2017 at 12:44 pm

    #1931336

  • RE: Why I am Excited about SQL Server on Linux

    loyd.gravitt - Thursday, March 2, 2017 9:20 AM

    I am very excited.  It takes two of my strongest skill sets (SQL Server and...

    March 2, 2017 at 12:37 pm

    #1931334

  • RE: Why I am Excited about SQL Server on Linux

    Markus - Thursday, March 2, 2017 7:06 AM

    From what little I have read SQL Server on Linux, at this point, is missing...

    March 2, 2017 at 12:32 pm

    #1931331

  • RE: Why I am Excited about SQL Server on Linux

    Gary Varga - Thursday, March 2, 2017 12:50 AM

    Some good points, however, I am interested at a level of "Wait and See"...

    March 2, 2017 at 12:12 pm

    #1931323

  • RE: Signatures & Database Triggers

    Sean Lange - Monday, November 7, 2011 9:41 AM

    OH this is a ddl trigger. You can't add a signature to DDL triggers. http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/1333eecd-4c66-43d4-ab8f-03511cad4174

    Nor...

    January 19, 2017 at 3:32 pm

    #1923901

  • RE: Need CLR replacements for OLE Automation procedures

    Marios Philippopoulos (5/20/2009)

    Hi,

    Anyone have CLR code for replacing the functionality offered by the following procedures?

    sp_OACreate

    sp_OADestroy

    sp_OAGetErrorInfo

    sp_OAGetProperty

    sp_OAMethod

    sp_OASetProperty

    sp_OAStop

    Also, currently on our SQL-2000 instance, these procedures are being used for making web-service calls. Does...

    December 19, 2016 at 1:01 pm

    #1918761

  • RE: Is there a way to extract only credit card numbers from text

    And I just thought of another variation of what I proposed above, taking into account that the goal is to replace the offending card numbers and transaction IDs with "x"s....

    December 15, 2016 at 4:28 pm

    #1918309

  • RE: Is there a way to extract only credit card numbers from text

    I am replying to both of the following posts together as there is a lot of overlap between them:

    Luis Cazares (12/2/2016)

    SQLsharp has a validation for credit cards. It will only...

    December 15, 2016 at 4:02 pm

    #1918306

  • RE: Is there a way to extract only credit card numbers from text

    TheSQLGuru (12/10/2016)

    Very slick! Sadly I seem to be unable to get to the SQLSharp.com website via multiple browsers. 🙁

    D'oh! My hosting provider did a server migration recently and I thought...

    December 10, 2016 at 10:03 am

    #1917249

    • Viewing 15 posts - 241 through 255 (of 645 total)