DB2 SQL Valuable Lessons Learned - Cross Platform
IBM DB2 GOLD Consultant Sheryl Larsen shares DIRTY LAUNDRY ...
In episode #31, special guest Sheryl Larsen, IBM DB2 GOLD Consultant and Owner www.SMLSQL.com, aired her dirty laundry! Well, her client's dirty laundry that is! In this informative episode, Sheryl examined SQL performance lessons learned from recent consulting engagements with clients. The SQL information provided applies to DB2 z/OS and LUW! Learn about indexes, stages, sargability, and so much more! Watch the replay to learn from her wisdom...
We'd also like to bring to your attention some upcoming shows:
- OCT 15 - DB2 LUW Performance Tuning Lessons Learned with special guest Martin Hubel, IBM DB2 GOLD Consultant. Really - you don't want to miss this - even if you don't have SAP!
- NOV 5 - The SQL Snapshot Potluck Party is BACK! Share your favorite SQL Snapshot command and receive the source code for the entire collection!
- NOV 19 - What's new and COOL with DB2 LUW with guest George Baklarz, IBM
Finally, also on 21 January 2011 at 2pm Central, DBI is offering a free Webinar "TEN SQL Snapshot commands you MUST run TODAY!" - this is a derivative work of Scott Hayes' IDUG Regional technical session. Attendees will receive the SOURCE CODE for these invaluable commands. DETAILS and REGISTRATION.
To download a recorded replay of Episode #31, right click on the link below and choose "Save As..."
Episode 31, 8 October 2010, Cross Platform SQL Tips with Sheryl Larsen
During this episode, Sheryl gave away two free seats to her upcoming seminars in Chicago, December 2nd and 3rd. Learn more about these seminars at www.SMLSQL.com. Sheryl Larsen and The DB2Night Show are pleased to announce these free class winners:
- Sue Rhode, Brookfield, Wisconsin
- Shauna Hadden, Topeka, Kansas
Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ now has a LinkedIn Group. The group is an open group. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!
Our Shameless Marketing Moment
During today's show, Sheryl gave us great advice for improving the performance of costly SQL statements. The challenge is, however, which statements are truly the most costly to the database workload? DBI's Brother-Panther® accurately identifies the SQL statements that are the most harmful to your database's performance - in just THREE mouse clicks!
DBI is offering a free educational webinar "TEN SQL Snapshots you MUST run TODAY" on Friday, 21 January, 2pm Central (3pm Eastern, 1pm Mountain, 12pm Pacific, 8pm GMT). Attendees will receive the SOURCE CODE for the SQL Snapshots! For details and the registration link to this free event, visit DBI's EVENTS page.
Our #2 Job is giving you the documentation to prove it!