Come, miscode some SQL with me…
Session Number: 2149
Track: General II (F)
Session Type: Podium Presentation
Primary Presenter: Suresh Sane [Database Architect - DST Systems Inc]
Speaker Bio: Suresh Sane is an IDUG Hall of Fame speaker who has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and DB2 Packages). He was recognized as an IBM Information Champion in 2009, 2010 and 2011. He is a long time IDUG volunteer and was the Conference Chair for IDUG NA 2008. He currently serves on the IDUG Board of Directors.
Audience experience level: Beginner, Intermediate
Presentation Category: Application Design
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: SQL and XML Features, SQL and XML Performance
Objective 1: SQL examples of DOs and DON'Ts
Objective 2: Let me count the ways I can code thee
Objective 3: Talking about Temporary tables
Objective 4: But it's just a small table?!
Objective 5: Making the optimizer read your mind
Abstract: Presentations advocating best practices abound. Welcome to the real world! We all know several bad practices are routinely followed in several shops. In addition, some ‚Äúclever‚Äù practices can be harmful in the long run. This session will cover some of the common patterns I have seen in my design reviews. We will discuss why they occur, how to detect them and how to prevent them.
For questions or concerns about your event registration, please contact email@example.com