Thanks everyone for the great blog and email comments on how we should deal with T-SQL casing conventions.

There was a lot of interesting feedback on casing conventions for T-SQL. In summary, the main feedback was

• Default capitalization should follow the documentation
• Capitalization has value for all the non-Visual Studio tools people use
• Intellisense should automatically capitalize according to user preferences
• Intellisense and color-coding should work for T-SQL embedded in, say, Visual Basic source code
• Many are moving to a .Net code style of naming but other conventions are in common use.

If you are interested in the operational side of database development MSDN has a great series of talks by Kimberly Tripp at http://www.microsoft.com/events/series/msdnsqlserver2005.mspx.

This posting is provided "AS IS" with no warranties, and confers no rights.