The DB2Night Show #31: Valuable SQL Lessons Learned with Sheryl Larsen


Posted by Scott on October 11, 2010, 7:43 pm
in Cross Platform ( The DB2Night Show)

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:


For show details, free registrations, and replays, kindly visit www.DB2NightShow.com


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.

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:


For show details, free registrations, and replays, kindly visit www.DB2NightShow.com


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:



Join The DB2Night Show™ LinkedIn Group


The 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 #1 Job is helping you look great!

Our #2 Job is giving you the documentation to prove it!


Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=217