TSQL''' - PowerPoint PPT Presentation

1 / 8
About This Presentation
Title:

TSQL'''

Description:

20 years in the IT Industry. Loves refactoring code ... A few standards to whet your appetite. CAPITALISE keywords. Indent your code ... – PowerPoint PPT presentation

Number of Views:19
Avg rating:3.0/5.0
Slides: 9
Provided by: chris737
Category:
Tags: tsql | whet

less

Transcript and Presenter's Notes

Title: 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.
Write a Comment
User Comments (0)
About PowerShow.com