Date: Tuesday, October 16th
Sponsor: SQLFarms
Refreshments: Pizza/Soda
Give-A-Ways: SQL Farms will be giving away 1-user license (full unlimited license) for each attendee in the users group session (limit 1-per company) - a ~$5K value each.
Topic: Best development and deployment practices for SQL 2000 and 2005
In this session we will dive into best SQL and T-SQL coding practices, optimizing code for collaboration and optimization, and cover the topics listed below.
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.
Dr. Omri Bahat is the CEO of SQL Farms, Inc., a software company that develops database management tools for mid-size to very large SQL Server environments and data centers. Before SQL Farms, Dr. Bahat served as the lead database architect at Symantec, responsible for database development, change management, and deployment in large SQL server environments. Dr. Bahat writes for SQL Server magazine, is a regular speaker in software conferences and SQL user groups, he manages the Northern VA SQL user group (http://www.novasql.com/), and in his spare time also runs the SQL Education Center (http://education.sqlfarms.com/).
SQLDiva