Replay- The DataView Show #17: Best Developer Features for Db2 z/OS V9-12 and LUW

Our special guest, Tony Andrews, shared his favorite newest developer features found in recent releases of IBM Db2. The enhancement lists are impressive, but the SQL tips are awesome! Be careful, you might get addicted to this replay!

Objectives:

  • Highlight the many new SQL enhancements and features from V9 to V12
  • Highlight the SQL enhancements that were especially helpful and efficient for developers
  • Covers SQL coding, optimization, and application design
  • Take away many great SQL examples

BIO for our special guest, Tony Andrews:
Tony Andrews has more than 25 years’ experience in the development of IBM Db2 relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and he has also served as a Db2 database analyst. For the past 10 years, Tony has been splitting his time between consulting engagements and training. His main focus is to teach today’s developers the ways of RDBMS application design, development, and SQL programming— always with a special emphasis on improving performance.

Tony is a current IBM champion and regular lecturer at industry conferences and local user groups. You may have seen him present at such events as IDUG NA and EMEA, and many regional users groups. He is a published author and is well known for his “Top 25+ Tuning Tips for Developers” presentations. Tony was awarded a ‘Best Speaker’ at the IDUG NA 2019 conference.

Tony Andrews, Db2 z/OS Expert, Teacher, Consultant
Tony Andrews, Db2 z/OS Expert, Teacher, Consultant, Themis Inc.

WATCH THE REPLAY

This show is 1hr 14 minutes long. Don’t miss a minute of it!

GET THE PDF

Tony was kind enough to share a PDF of his presentation. CLICK HERE to get your copy! Thanks!

Replay- The DataView Show #14: SQL Performance Best Practices – especially for Big Data

This presentation discusses the SQL best practices that are critically important as databases get bigger and more complex. This presentation will discuss the SQL writing techniques, table cardinality, index factors, and other consideration that make your SQL run faster. You will learn through this presentation SQL best practices tuning tips, the real life issues, and agile SQL considerations for working with Spring Batch, Docker Containers and other agile tools.

This presentation was developed for application developers to help them understand high performance SQL factors for running against tables that contain billions of rows. These SQL techniques, table factors and index considerations discussed show how small critical factors can make a big performance difference against big data tables. SQL functions, UDFs, common table expressions CTE and other SQL techniques are only some of the factors that need to be considered in the SQL development cycle. This presentation will help you understand all these SQL performance factors and the best practices used to get the fastest SQL results from your biggest tables.

About our special guest:
Dave Beulke and Associates is a customer-focused and results-oriented DB2 consulting, DB2 training and education and software company specializing in overall performance for all aspects of information technology. We specialize in IBM’s DB2 database running on any platform and help companies reduce CPU demands by as much as 40%, saving our customers millions of dollars. Through focused DB2 performance consulting engagements, we have improved computing performance of systems, databases, application and SQL reducing total cost of ownership and eliminating the need to upgrade computing hardware.

Stay safe, stay healthy, wash your hands, and visit http://www.DataViewShow.com for more free education. We love subscribers and appreciate your thumbs up!

Dave Beulke, IBM GOLD Consultant and Champion
Dave Beulke, IBM GOLD Consultant and Champion

WATCH THE REPLAY

97% of our HUGE live audience learned something! What will you learn?

GET A PDF

A PDF makes great reference material, but you are cheating yourself if you don’t watch the video above! Dave elaborates key points and addresses several audience questions! Get the PDF here!