EDS4 - SQL Coding and Tuning Magic from a Wizards Collection

Session Number: 4344
Track: EDSEM
Session Type: Educational Seminar
Primary Presenter: Sheryl Larsen [BMC Software]
Time: Apr 30, 2017 (09:00 AM - 05:00 PM)
Room: North Exhibit Hall Rooms G&H

Speaker Bio: Sheryl M. Larsen is a Sr. DB2 Product Specialist at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Data Warehousing and Business Intelligence, Implementing New DB2 Releases and Features, Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), New Release (DB2 for z/OS), SQL and XML Performance

Abstract:  Three decades of IBM DB2 SQL collection will be show techniques for coding crazy SQL and tuning crazy SQL. Examples will be shown from folks just offering their coding and tuning techniques to be shared, demonstrating effective and efficient solutions. Queries that are short and long to extremely long will impress even those with a high SQL skill. Leave with a soft copy so that examples can be copied and reused.