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 #13: IBM THINK Updates plus Data Science Masterclass and Hackathon

During this show, Colleen Bisconti, IBM VP Global Events and Conferences, gave us an update on the new, re-imagined, IBM THINK virtual conference May 5-7, 2020. Get the scoop from Colleen during the first 15 minutes, then visit www.ibm.com/think to register for this FREE virtual conference!

Following Colleen, Aylee Nielsen, IBM Community Manager, and Austin Eovito, Data Scientist, gave a compelling presentation about the new Data Science Masterclass and Hackathon with an $8,000 prize pool. Austin’s presentation on EXPLAINABILTY was very intriguing. To learn more about the Masterclass and Hackathon, visit: https://ibm-explainability.bemyapp.com

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!

Think about THINK plus Data Science Hackathon
Think about THINK plus Data Science Hackathon

Watch the Replay!

IBM THINK updates during first 15 minutes, then news and information about Data Science Masterclass and Hackathon during the remainder of the show.

Get a PDF!

CLICK HERE to get a PDF copy of Austin Eovito’s presentation on Explainability. His presentation includes references to several helpful resources and papers.

Replay- The DataView Show #12: Protecting Sensitive Data with IBM Guardium – Customer Experiences and Advice

During this show, our guest speaker, Tim Tait, IBM Champion, covered an overview of Guardium and its many features that can be used to monitor and protect Sensitive Data. He also covered examples of how data security practices are implemented within his organization using Guardium.

About our special guest:
Tim Tait is a data security professional who has been working with Guardium for 9 years. He has been the driving force for the shift from compliance reporting to a security focused Guardium environment. He is responsible for all facets of Guardium including infrastructure and data administration. Tim is an IBM Champion and is highly regarded as a top expert in his field by many IBM professionals.

Tim Tait, Data Security Specialist, IBM Champion

Watch the Replay!

Don’t miss a minute of it! Our audience asked great questions!

Useful Links

Guardium Supported Platforms

Integration of Guardium with Cloudera Hadoop

IBM Security Guardium User Community

Replay- The DataView Show #11: IBM Cloud- Get Started and Make your business Agile!

No slides! All Demo! 100% of our audience learned something! #Awesome

Our guest, Simon Lightstone, demonstrated how to build a Chatbot in less than 15 minutes, and then he demonstrated using IBM Db2 in the Cloud. And you can do all this yourself for FREE (no credit cards required)!

Simon Lightstone, Managing Partner, Levion Partners
Simon Lightstone, Managing Partner, Levion Partners

Watch the Replay!

2020 State of the Db2 Universe Study

There is still time to participate in the 2020 State of the Db2 Universe Study! You could win a badge to IDUG Dallas June 4-7 or one of five $50 Amazon.com gift cards, or you can opt out of winning if you hate winning. Study results will be shared with participants (must provide your email). Make your Db2 voice heard by CLICKING HERE and completing the survey. The study closes 2 March 2020 at 9pm CST. Thank you!

Replay- The DataView Show #10: AI in BI: Augmented Intelligence Built into IBM Cognos Analytics

This session explored in detail the AI architecture built into IBM Cognos Analytics. You will learn how machine learning, natural language processing, ontologies and other cognitive capabilities are continuing to improve the user experience in IBM Cognos Analytics. Discover how traditional steps in the business intelligence process are now automated to create a simplified user experience. You’ll also discover how the AI in Cognos Analytics offers another perspective in making unbiased data-discovery a reality. You can learn more about Cognos and AI by visiting: https://www.ibm.com/products/cognos-analytics

Jason Tavoularis, Offering Manager, IBM Cognos
Jason Tavoularis, Offering Manager, IBM Cognos

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!

2020 State of the Db2 Universe Study is OPEN until 1 March 2020.

If you use Db2 z/OS or LUW, please participate in the 2020 State of the Db2 Universe Study. It only takes 10 minutes and you could win a badge to IDUG Dallas June 7-11 or one of five $50 Amazon gift cards.

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!

Replay – The DataView Show #8: “Theory to Practice: Db2 HADR in the Real World” with guest Ember Crooks

Famous blogger, IBM Champion, and IBM Gold Consultant Ember Crooks presents her real world experiences and best practices for using Db2 HADR. She describes her presentation as follows:

Have you ever seen the “poison pill” message in your Db2 diagnostic log just before Db2 crashes to prevent split brain? Have you ever needed to know before implementing HADR or changing the SYNCMODE what the performance impact might be on your primary database? Join Ember to learn the planning and decisions behind an HADR implementation and the tools to make your work with HADR successful. Hear stories from HADR challenges and problems in the real world.

If somehow you aren’t friends with Ember yet, here is her short BIO:

Ember has 18+ years of experience with Db2 on Linux, Unix, and Windows platforms. She is the founder and principal author of the popular www.datageek.blog technical blog where she educates herself and others through example and case study. Ember is an IBM Gold Consultant and IBM Champion in Information Management, and she is a very popular top speaker at IDUG conferences worldwide. You can follow Ember on Twitter at @ember_crooks.

Ember Crooks, IBM Champion and Gold Consultant
Ember Crooks, IBM Champion and Gold Consultant

98% of our HUGE studio audience learned something from Ember! The recording is 1 hour 12 minutes long and you won’t want to miss a single minute of it. Ember has kindly agreed to make her slides available, but you need to hear her explanations, see the screen animations, and experience the many great questions from our audience!

Watch the Replay!

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

Get the PDF Handout

PDFs make great reference material, but make sure you watch the replay – it’s the only way to benefit from screen animations, Ember’s explanations, and learn from the many great questions that our audience asked! GET THE PDF HERE.

More Helpful Links

Visit www.IDUG.org for Db2 articles, blogs, and conference information. Register for IDUG Dallas June 7-11, 2020, and take advantage of Early Bird registration savings!

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

Check out the new FREE IBM Db2 Augmented Data Explorer Tool. It’s a cool GUI with AI built-in that will help you mine knowledge from your data!

Have you tried the new IBM Data Management Console yet? DMC is the successor product to IBM DSM.

Get your feet wet and your mind invigorated with Artificial Intelligence by checking out Watson Auto-AI.

Replay – The DataView Show #7: “Db2, The AI Database, and managing data efficiently in a hybrid cloud world”

For episode #7, IBM Executives Matthias Funke and Thomas Chu were our special guests. They offered this description for their presentation: “Learn how to modernize data architectures, avoid lock-in and drive economic value across a hybrid cloud data architecture with the AI database that both leverages and supports AI.”

Matthias Funke, Thomas Chu, IBM Db2
Matthias Funke, Thomas Chu, IBM Db2

97% of our huge studio audience learned something! This session was quite interactive with many questions from our audience. You will learn about future directions, IBM strategies, Netezza futures, Informix futures, AI, The Db2 Augmented Data Explorer, pureScale, Db2 on z/Linux, Cloud, Cloud Paks, and more.

And have you ever heard IBM executives sing before? Don’t miss it! Today was Stuart Litel’s 21st birthday and we celebrated his efforts to make The DataView Show possible!

Watch the Replay!

This show is 1 hour 8 minutes long and we hope you enjoy every minute of it!

Get a PDF Handout

Our guests graciously offered to provide a PDF of their slides. However, don’t just grab the PDF and read it – you’ll want to watch the replay too because there were many excellent questions from our audience and our guests covered many topics not included on the slides! GET THE PDF HERE.

Links you may like

Visit www.IDUG.org for Db2 articles, blogs, and conference information. Register for IDUG Dallas June 7-11, 2020, and take advantage of Early Bird registration savings!

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

Check out the new FREE IBM Db2 Augmented Data Explorer Tool. It’s a cool GUI with AI built-in that will help you mine knowledge from your data!

Have you tried the new IBM Data Management Console yet? DMC is the successor product to IBM DSM.

Get your feet wet and your mind invigorated with Artificial Intelligence by checking out Watson Auto-AI.

The DataView Show #6: The New IBM Data Management Console with guest Peter Kohlmann, IBM

Peter Kohlmann, IBM
Peter Kohlmann, IBM

The new Data Management Console for IBM Db2 is the successor product to IBM DSM. During this show, Peter Kohlmann shared a great deal of information about the DMC, its features and capabilities, design considerations, APIs, interfaces, and more. Most of the show includes live demonstrations of DMC, and Peter skillfully fielded several great questions from our live audience (a benefit of attending the live webinars!).

If you haven’t joined the IBM Community yet, you should. It is segmented into focused groups or areas where you can explore and discuss various IBM technologies. The Data Management Console has a group within the IBM community and there are several interesting conversations taking place between early users and IBM product developers and managers. You can get the DMC free and get involved by simply visiting www.ibm.biz/Db2Console.

A common question amongst viewers was “Is there support for IBM Db2 for z/OS?” and Peter’s answer was that support is coming 1H 2020. Also, there’ll be a new code drop/release of DMC coming in January 2020 that will add more features and capabilities. We’ll bring Peter back for DMC updates next May or June 2020.

Watch the Replay!

You can also view this video directly on YouTube by visiting https://youtu.be/XFp31tclyu4 – please subscribe to our YouTube channel! Thank you!

Enjoy the holidays!

The DataView Show #5: The SPEEDup of Everything!

We are sorry. A replay of this show cannot be made available. Our guest, Paul Zikopoulos, IBM VP, had content in his presentation with copyright and other licensed use restrictions. Sometime in the near future, we hope to make an MP3 audio recording of Paul’s topic available. Stay tuned.

Enjoy the holiday season.