Esoteric

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

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

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