TSQL'''

1
T-SQL... Interactive Coding Standards
2
Amanda Jackson

• Senior Developer with Fronde Systems Group Ltd
• 20 years in the IT Industry
• Loves refactoring code
• Pet peeve slap dash, untested code of any
  variety
• Started Girl Geek Dinners in NZ
• Started Auckland SQL Server UG with Dave Dustin

3
Session Overview

• What are coding standards?
• Why do we need them?
• Quick list of standards
• The interactive bit show us your brains!

4
What are coding standards?

• A set of rules that tells developers in a team
  how to write their code, instead of each
  developer coding in their own preferred style.

A set of rules that tells developers in a team
how to write their code, instead of each
developer coding in their own preferred style.
5
Why do we need coding standards?
A set of rules that tells developers in a team
how to write their code, instead of each
developer coding in their own preferred style.
Maintainable Code
6
A few standards to whet your appetite

• CAPITALISE keywords
• Indent your code
• Comments, comments more comments
• Do not call functions repeatedly
• No anonymous inserts
• Dont use select
• Avoid using not equals operators
• Dont use hardcoded values
• Catch errors

7
Ideas time....
8
Resources

• A set of coding standards will be made available
  to download from my blog.
• Blog http//nzgirlgeek.blogspot.com
• E-mail amanda.jackson_at_fronde.co.nz
• Websites that have helped me in my search for
  coding standards nirvana
• http//www.sqlserver.org.au/
• http//www.cslacey.co.uk/TSQLCodingStandards.pdf
• http//www.pinaldave.com/sql-download/SQLServerGui
  deLines.pdf
• http//www.sql-server-performance.com/articles/dev
  /sql_best_practices_p1.aspx
• http//www.sqlserver.org.au/

9

• Thank you.