Daily Archives: July 31, 2012

Password Resets

I read this piece from Troy Hunt, which is a long look at the password reset process for a web application. It’s one of the first that I’ve seen which talks about the different implementations, along with the pitfalls and … Continue reading

Posted in Blog | Tagged , ,

Creating a DDL Trigger

One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to the server. As with any trigger, these can be problematic in that they can overload a server, and they ALWAYS … Continue reading

Posted in Blog | Tagged , , | 2 Comments

The DBA Database

Do you have a DBA database on all your instances? I’ve always kept a small database on all instances, usually standardized with a set of tables and procedures that I used to monitor and track activity on the instance. By … Continue reading

Posted in Editorial | Tagged ,