Daily Archives: July 31, 2012

Password Resets

Posted on July 31, 2012 by

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

Posted on July 31, 2012 by

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

Posted on July 31, 2012 by

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 ,