Monthly Archives: July 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 ,

#GetHawt – The Summer 2012 Edition

Posted on July 30, 2012 by

Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so she started an invitation for a summer competition. Silly me hadn’t been paying much attention, even though I’d seen the … Continue reading →

Posted in Blog | Tagged ,

Better Bosses Needed

Posted on July 30, 2012 by

Raise your hand if you have a bad boss. Now raise your hand if you’ve ever had a bad boss. I can’t quite make a count, but I’m hoping that those of you with raised hands constitute a minority of … Continue reading →

Posted in Editorial | Tagged

Performance Data

Posted on July 27, 2012 by

A good DBA is monitoring their system, looking for problems on a regular basis. The best DBAs are pro-actively heading off future issues by tuning or adding resources to their systems before a problem surfaces. It seems, however, that it’s the rare … Continue reading →

Posted in Editorial | Tagged

Leaving Some Headroom

Posted on July 26, 2012 by

I was reading this piece on scaling Dropbox and something caught my eye. It’s a very interesting read, especially if you deal with scaling, and I’d encourage everyone that works with technology to read it. The one thing that really caught my … Continue reading →

Posted in Editorial | Tagged ,

Sacramento SQL Saturday Here I Come

Posted on July 25, 2012 by

Packing for SQL Saturday #144 in Sacramento, CO. Dan Hess, one of the organizers, asked me last November at the PASS Summit if I’d come. I told him I’d try, and the scheduling worked out. As soon as I was … Continue reading →

Posted in Blog | Tagged , ,

A Really Good Job

Posted on July 25, 2012 by

I write a decent amount about career topics. In the discussions for these pieces, all too often I see comments from people that they aren’t happy with their job. They have a bad boss (which is really bad), or they aren’t … Continue reading →

Posted in Editorial | Tagged | 1 Comment

DevConnections – Fall 2012

Posted on July 25, 2012 by

This fall is the DevConnections SQL Server Connections conference in Las Vegas again. It’s at the Bellagio, setting for one of my favorite movies, Ocean’s 11. It’s a smaller conference this time, and SQLServerCentral only has 4 slots for the … Continue reading →

Posted in Blog | Tagged , ,