Bravo, Steve!  A superb description of formatting standards, as well as the justification for using each element! 

I have used almost exactly the same standards since shortly after I started...

Joe,

Being a data modeling purist, I completely agree that using PK/FK suffixes, naming a data element for how it is used, is WRONG.  But, we're talking about PHYSICAL database design...

Almost hit the nail on the head.  I could not agree more about using proper case for names in SQL Server - many studies have shown that mixed case is...

One reason databases SHOULD be case sensitive:  Development!  Several years ago (back in the days of SQL 6.5), I worked for an HR systems vendor in Denver.  The first time...

One of the best tools out there, regardless of cost, is EasyCASE from Evergreen CASE Tools

No such luck.  I copied the text out of the log, and pasted it into a call to XP_SENDMAIL - it came through to both my e-mail inbox and pager...

MY message shows up in the log, not the generic one, and SQL Mail is configured properly - I receive test e-mails AND pages when I test those for the...