IDUG EMEA has ended
Back To Schedule
Tuesday, October 25 • 14:40 - 15:40
PSP10 | How to Keep Bad SQL Out of Production | Presented by BMC Software

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Just because SQL provides the right data back to a program for processing does not mean it’s “Good SQL.”  Also, SQL can change from bad to good as your systems mature and tables grow from small to huge, but there are ways to monitor production SQL to identify those programs that would benefit the most from tuning. Join us as we explore ways to manage SQL quality and performance. Learn how to shift left quality and performance SQL issues with BMC AMI SQL Performance for Db2. Quickly identify and tune your most resource-intensive SQL statements at each stage of development to reduce CPU consumption while improving performance and availability. Also learn about best practices for developing SQL, using graphical representation of explain data to estimate cost of the query, and testing SQL in a high-volume environment to understand performance optimization opportunities, and how to enforce SQL coding standards to adhere to custom site rules leveraging a modern mainframe DevOps process.  

avatar for Michael Cotignola

Michael Cotignola

Db2 Software Consultant, BMC Software
Michael Cotignola is a Principal Software Consultant supporting BMC's DB2 Mainframe Solutions. In this role, he helps his clients maximize the value they receive from BMC's DB2 products. Michael has worked in IT since 1975 in numerous IT disciplines, including operations, application... Read More →

Tuesday October 25, 2022 14:40 - 15:40 BST
0 | Tinto