During Episode #16 of The DataView Show, Keri Romanufa, IBM STSM and Db2 Chief Architect, gave highlights of everything that is new in Db2 11.5, plus did a deep dive on her favorite “Top 10” new features and capabilities.
Keri also fielded dozens of great questions from our HUGE live audience. 99% of our studio audience learned something from Keri – what will you learn? Some questions were asked during Keri’s awesome presentation, but most are asked and answered near the end during the Q&A.
We encourage you to Subscribe to The DataView Show channel on YouTube so you don’t miss any free education about IBM Data and AI technologies. And, if you learn anything helpful, we’d sure appreciate your likes! Likes make our guests smile! Thank you!
WATCH THE REPLAY
This show is 1 hour 22 minutes long thanks to all the great questions that our audience asked. Grab your favorite beverage and enjoy the show!
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!
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!
The DataView Show is super excited to present Raghu Cherukuru, aka “Raghu on Tech” on 21 November 2019, 11am Central. Raghu will teach his best Db2 LUW Performance Tips and Tricks! CLICK TO REGISTER!
On 5 December 2019, The DataView Show will host the FAMOUS Paul Zikopolous, VP of Big Data Cognitive Systems, IBM. Paul has been on TV shows, written 19 books, and appeared on many top lists of “who’s who” in Big Data. “The SPEEDup of Everything will talk about some AI uses cases, the problem with data, how AI is going to help us … and how you get your AI going faster.” CLICK TO REGISTER!