Hotsos Training Day

Karen MortonHotsos is very pleased to announce that Karen Morton is the speaker for this year's training day, scheduled for March 10, 2011.


Karen Morton is a consultant and educator specializing in application optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is a Senior DBA Performance and Tuning Specialist for Fidelity Information Services.

For over 20 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is a researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle over a decade ago.

Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network (an informal association of "Oracle scientists" that are well known throughout the Oracle community). She blogs at


The topic for Training Day 2011 is: Managing SQL Performance - Practical Information and Tools for Writing and Maintaining Optimally Performing SQL.

The aim of this training day is to make managing how SQL performs an engrained/automatic part of your application lifecycle. Managing how your SQL performs shouldn't be a job assigned to one person or role, but the job of everyone involved in the development and on-going maintenance and support of your applications. Tools and techniques learned will help you write better SQL faster and enable you to quickly diagnose poorly performing SQL. You'll also learn how to recognize and correct many common antipatterns that may be present in your current code that are problems waiting to happen.

The first part of the day will cover how to establish a mindset within your organization that makes SQL performance a part of everyone's role. We'll review tools and techniques that fit into each step of the application development and maintenance lifecycle and that make writing and maintaining good SQL easy and straightforward. The use and "how to" of proper instrumentation will be covered so your code can help you locate and diagnose future problems quickly.

During the second half of the day, we will review several common SQL antipatterns, patterns of coding SQL that are commonly used but that are ineffective in actual practice. You'll learn how to locate and correct these antipatterns to help make your application SQL more stable and less resource-intensive, not to mention faster!

You'll leave with a "can do" attitude about managing SQL performance, a set of tools/scripts you and your team can share to help make SQL tuning easier and more reliable, and a list of code antipatterns to seek out and destroy in your applications. Every demo and script will be made available for your use via download from the Hotsos website.


Training Day will begin at 8:30 a.m. and end at 4:45 p.m.


  • $500

Registration Cancellation Policy

Karen Morton, the Grand Poo Bah of SQL, wants you to sign up today!

  • 100% refund if cancelled on or before December 31, 2010
  • 50% refund if cancelled between January 1, 2011 and February 11, 2011
  • Cancellations submitted February 12, 2011 and after will not be refunded