Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: Max Length of AD Names for Security

    Interesting discussion on the maximum login lengths. My experience:

    You can create an AD Login of any size up to the max allowed.

    However, if two AD logins that...

  • RE: Learning C

    I do think that working with more primitive languages gives you some insight that higher level languages do not. Assembler was essential at one time, even on mainframes. ...

  • RE: The DBA Database

    I have DBA databases on my servers as well. Doing much the same things that others have described. Absolutely essential.

    In addition to all the private DBA stuff, we...

  • RE: A brief explanation and solution for the Double Hop problem

    One question I imagine other readers might have, "how would the implementation steps differ, if at all, were both ServerA and ServerB using the same SQL Server Service Account?".

    They will...

  • RE: Lost Data

    Get a RestoreTest server (a VM would be fine) and enough disk space to restore your biggest database (plus necessary overhead).

    Then cycle through your servers, restoring the backups...

  • RE: Is It Worth Upgrading to SQL Server 2008

    Actually, backup compression was announced to be available in Standard Edition of SQL Server 2008 R2, when it is released. Apparently scheduled for sometime in 2010. (Just...

  • RE: Simple LEFT JOIN gives surprising result - Why?

    You know that I have high regard for your T-SQL understanding.

    But, sorry, but I don't think this needs a warning any more than many other sneaky behaviors of...

  • RE: Simple LEFT JOIN gives surprising result - Why?

    Yes, subtle and the reason that I (almost) never use a constant in the ON. By adding one more row to the original query it becomes clearer:

    create table a...

Viewing 8 posts - 1 through 8 (of 8 total)