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

#GetHawt – The Summer 2012 Edition

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

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

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

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

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

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

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 , ,