Sessions - David Penton

Speaker

David Penton

Session

Increasing Developer Productivity With SQL Server

Room

109

Track

SQL

Time

10:00

MVP

Description

There are many choices to be made when building tables in a database. The queries you likely need are based in part on the level of normalization, index structure, and of course business requirements. In this talk I'll give a refresher on indexs and some table design, SQL syntax - such as JOIN Syntax (INNER, LEFT, RIGHT, FULL) and the EXISTS statement and benefits. I will talk about the benefits of Derived/Immediate views and other query techniques. This will focus on ANSI SQL from a SQL Server perspective.

Bio

David L. Penton lives in the Dallas, Texas area and has a bachelor's degree in Mathematics from Northwestern State University (http://www.nsula.edu), Natchitoches, LA. He currently is a Lead Software Development Engineer / Performance Lead at Telligent Systems, Inc (http://telligent.com). Before that, he was a technical lead for the International Systems Group and then in Merchandising Systems at JCPenney, Inc. (http://www.jcpenney.com), in Plano, TX. Before that, he was a senior business and analysis analyst for Lockheed Martin Missiles and Fire Control (http://www.lockheedmartin.com/mfc/) in Grand Prairie, TX. During that time he has worked on various technologies. He currently spends most of his time with C# and SQL Server. Database platforms he has dealt with (development and admin) include but not limited to SQL Server, Oracle, DB2. David is a member of the ASPInsiders (http://aspinsiders.com) and was formerly a SQL Server MVP for several years.

2008.3