IDUG DB2 Tech Conference EMEA 2011
    Clarion Congress Hotel, Prague, Czech Republic
    14 - 18 November, 2011

    View Printable Version

    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]
    Room(s)/
    Time(s):

    Kepler => Mon, Nov 14, 2011 (01:30 PM - 02:30 PM)

    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 support@idug.org


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact