Tonight - Best development and deployment practices for SQL 2000 and 2005
Best DDL and Schema design
Understanding the SQL server DDL architecture
Design considerations for tables and view
Indexes, constraints, keys - when, where, and how to apply them best
Writing DDL in collaborative dev teams
DML, stored procedures, functions
Writing efficient SQL code
Clean and clear development practices
Do's and Dont's when writing SQL code
Security considerations
Best deployment practices
Database projects and releases
Moving code between Dev, QA, and Production
Writing good code to eliminate deployment issues
Presenter: Dr. Omri Bahat, CEO of SQL Farms, Inc.