Seminar Program

Date: March 8, 2017 - Seminar Agenda

Location: The Crowne Plaza Hotel , Novi Michigan

8:15am - 9:00am Check In / Continental Breakfast
9:00 am - 9:05 am Meeting kickoff and Opening comments
9:05 am - 10:20 am "SQL Performance in the Digital World (Part 1)”
Speaker: Sheryl Larsen (BMC)
Download "SQL Performance in the Digital World (part 1 & 2) "
10:20 am - 10:40 am Break
10:40 am - 12:00 pm "SQL Performance in the Digital World (Part 2)”
Speaker: Sheryl Larsen (BMC)
12:00 pm - 1:00 pm Lunch - included as part of the seminar
1:00 pm - 2:15 pm "Stored Procedures & SQL PL”
Speaker: David Simpson (Themis)
Download "Stored Procedures & SQL PL”
2:15 pm - 2:30 pm Break
2:30 pm - 3:45 pm "Fun with SQL"
Speaker: David Simpson (Themis)


Presentation Abstracts

Presentation #1:

Speaker: Sheryl Larsen (BMC) - "SQL Performance in the Digital World (Part 1)”


The Digital World includes all kinds of transactions most of which contain SQL. Trapping and fixing nonperforming SQL has gotten more complicated or has it? The speed at which SQL performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should never happen. Come learn tips and techniques that can assist you in today’s Digital World.

Objective 1: When your monitors find this, what should you do?

Objective 2: What crazy SQL can do to you?

Objective 3: Finding the most expensive query running in the peak

Objective 4: Some old and new tuning techniques

Objective 5: Monetize your MLC savings with compares

Presentation #2:

Speaker: Sheryl Larsen (BMC) – "SQL Performance in the Digital World (Part 2)”


Part 2 of Sheryl’s first presentation

Presentation #3:

Speaker: David Simpson (Themis) – "Stored Procedures & SQL PL”


Learn to code simple programs in the SQL Procedure Language (SQL PL). This is the language used by most stored procedures being written today on DB2 for LUW and z/OS. We’ll see the basics of the syntax and discover just how easy it is to code stored procedures using this language.

Presentation #4:

Speaker: David Simpson (Themis) – "Fun with SQL”


This session is an interactive, hands-on, fun way to learn more about the SQL language. Operating as a SQL Dojo, attendees will work in groups to solve a series of SQL challenges provided by the session leaders. Groups will alternate and share time on the keyboard in five minute segments. Each group will try to solve the challenge and can accept suggestions from other participants. Session leaders will provide possible solutions at the end. There will be a mix of small and big challenges - some easier, some more difficult. Show off your SQL mojo while enjoying this SQL dojo.

Here is a link to a video about Fun with SQL


Speaker Biographies

Sheryl Larsen (BMC)

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 -, and a member of the Northern Illinois University Computer Science Alumni Council.

David Simpson (Themis)
David Simpson is currently Vice President at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.