Recently a project came up where we had to integrate user login information in our database with the users Windows Authentication on the network.
Peter did a great job of implementing this using the very handy CGI variable : #cgi.auth_user#
When a person logs in using WindowsNT authentication, ColdFusion passes the users login name in the variable cgi.auth_user
Peter kept a field in the users database called usersNetworkLogin and if the users session data was 0, he looked up the database against this variable. If a user was matched, he set the user logged in with session.loggedInUserId set to the users actual id from the database.
To save a dbs lookup in the future he set a cookie on the users machine.
This is a small bit of code and logic but has helped us out enormously on the Intranet project we were working on.......