Esoteric

The inside scoop on SQL / debugging you won't find anywhere else!
Posts
  • Esoteric

    The role of STOPAT in RESTORE DATABASE

    • 1 Comments
    Previously in SQL Server 2000, the STOPAT clause was provided for RESTORE LOG wherein you can "halt" the recovery process at a particular point in time. This feature is very useful for recovering from accidental user errors and such. Now in SQL Server...
  • Esoteric

    Enforcing password policy for all SQL Authentication Logins

    • 0 Comments
    One of my customers recently asked me how we can enforce the CHECK_POLICY option for all logins created on the SQL 2005 instance. Since by default this is enforced on a per-login basis, we cannot by default have it at a server level. But by using DDL...
  • Esoteric

    Connectivity related questions

    • 0 Comments
    Some time back there were some connectivity related questions thrown at me: Q1. We know about the Dedicated Admin Connection (DAC) and how it is useful for troubleshooting service hang issues. We also know that DAC should only be used when necessary...
Page 1 of 1 (3 items)

June, 2007