Friday, March 13, 2009

AOL and OpenID

I am not sure why it is so difficult to find the format for using AOL and OpenID or any OpenID for that matter. Not even Wikipedia has this information.

To sign in to a site supporting OpenID with AOL screename credentials, simply use the following format:

openid.aol.com/username

It really is just that simple. Too bad most sites talking about OpenID talk about how to setup your own OpenID - mostly developer speak, but nothing on how to actually login - unless you really dig for it.

Thursday, March 12, 2009

Checking Database Integrity

There are at least two commands one can run to check the integrity of a MSSQL database. They are:

DBCC CHECKCONSTRAINTS

and

DBCC CHECKDB

The latter actually runs the following inclusively, so unless you want to be extremely granular about your process, you only need run DBCC CHECKDB:

  • Runs DBCC CHECKALLOC on the database.
  • Runs DBCC CHECKTABLE on every table and view in the database.
  • Runs DBCC CHECKCATALOG on the database.


Here is Microsoft's excellent reference:
http://msdn.microsoft.com/en-us/library/ms188796.aspx