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!

Replay – The DataView Show #9: “Marketing Challenges and Puzzles”

Buell Duncan, IBM VP Marketing, was our special guest, and it sure was a special show! 100% of our live audience learned something! Feedback from our audience was extremely positive! This wasn’t our usual “technical” show, but instead a show that was insightful, fun, and informative, and you will learn great advice that will be helpful to your IT careers!

Buell shared many insights about IBM strategies and priorities. He told stories. He shared advice. It was awesome! Do not try to serve him a Pimento Cheese sandwich!

Buell Duncan, IBM VP Marketing
Buell Duncan, IBM VP Marketing

Here are some of the questions that were asked: How will IBM make our lives awesome? And how is IBM getting the word out? What keeps you up at night? What do you worry about? Why should someone attend the IBM Think Conference? Do you remember your first day at IBM 45 years ago? How much did that suit cost? Besides your current job at IBM, what was a previous favorite and why? What was the favorite thing you learned or did during your IBM career? If you could do anything different over the last 40 years at IBM, what would that be? (Host Scott Hayes LOVED his answer) Do you have any career advice for IT people? (Hint: keep skills sharp and mind your attitude, and more). What is the IBM culture like, and how has it changed? Arvind, the new CEO of IBM, is your boss – have you spoken with him yet and how did it go? What is the importance of Data? Of AI?

WATCH THE REPLAY

Please subscribe to The DataView YouTube channel. And “Thumbs Up” likes are always appreciated!

The DataView Show is sponsored by The IBM Community. If you haven’t joined yet, you’re missing out!