Main Menu       Contact Us

Main Menu 

  Onsite Training

• 1 Low Price

• Up to 12 People

Training at your Desk!

• Instructor-led training over the web!

• Morning Lectures

• Hands-on Lab

  Downloads

  Tools:

• JSTuner

• JS Analyzer

   Newsletters

• Puzzler Answer

  Speaking Topics

  Seminars

• Job Search

• 1-day Technical

Dan Hotka:

• Who is Dan

• Resume

• What they say...

Contact us

What They Say about Dan Hotka

Companies who have benefited from my training/services:

ACT, Alliance Technologies, Allstate Insurance, AmDocs, Anheuser-Busch, APAC, AstraZeneca, Atex Media, BAE Systems, Baxter Co, Bectel-Bettis, Inc, Blue Cross/Blue Shield, Boston Scientific, Butler Mfg, City of Cedar Rapids, City of Ft. Collins, City of Norfolk, City of Portsmouth, City Utilities, Comcast, Data Sciences, DeCare Systems Ireland, Dekod, Denso, Dice.com, Direct Tech, Inc, E & J Gallo Winery, EMC, Flexco, Foremost Farms, General Mills, Goodman Fielder, GTX, Hon Office Furniture, ICBF, IDOT, IFMC, IHSenergy, Infineon, Irish Cattle Breaders Federation, IRS, International Paper, Iowa Telecom, Johnson County Community College, Lockheed Martin, Kansas University, Kansas State University, Kinematik, Koios, KRKA, LDS Church, LifeTouch, Logica, Medco, Mid American Energy, MIT Vacations, National Security Technologies, Nationwide, Navy, Northrup Gruman, Novartis, Now Health Group, Oracle Corp, Pearson Education, Perodua,  PIC, Pioneer Hybred, Pleasant CO, Proekspert, Prosoft, RX America, Quinn Healthcare, Raiffeisen Bank, Sentry Ins, State of Florida, State of Michigan, Steel Warehouse, TDS Telecom, Tele2, The Star, Trinity Logistics, TIS, TriStateGT, Trutek Inc, University of California, University of Chicago, University of Iowa, University of Minnesota, US Cellular, USCG, US Cellular, VMWare, Vallent Technologies, Washburn University, Webmedia, Wells Fargo, Xerox Singapore, Zira

Feedback from RMOUG 2011

This was a near perfect score for my 'All the Free Stuff' Presentation

What were the strengths of this presentation?  

 85% gave me a 5, 12% gave me a 4!

 What recommendations do you have for improvement of this presentation?  

 ...I enjoyed this comment!

Feedback from a recent Web-based SQL Tuning class... (April 2011)

John Rose says: Have been employing well the learning with which I came away from your SQL tuning course, and am wondering about the upcoming schedule for your Advanced PL/SQL Tips and Techniques course.

Your half day lecture format is perfect by the way. I am sure you get a lot of similar comments, but being able to spend the afternoon catching up on normal duties and getting some time to review and prepare for the next day really increased the learning 
for me.

The week following the course, I discovered a SQL statement in one of our major applications that had consistently been running for over four and half minutes before returning data. Applying newly found knowledge, a few indexes and the Quest Optimizer, I was able to reduce the time to less than one quarter of one second. An unusual and extreme case certainly, but it sure makes it easy for me to pick out my next Dan Hotka Training!

Feedback from a recent Web-based SQL Tuning class... (April 2011)

It was a very good course.  The instructor was very clear in explaining the course.  I wish I could apply all of what I learnt.  

Very informative.  Going to help me write better SQL code.

Very knowledgeable instructor and course materials is full of excellent information including SQL code examples & techniques, multiple ways to get & interpret explain plans and  references to other materials (ie white papers, book, websites, etc)

Feedback from my All the Free Stuff ppt at RMOUG... (Feb 2011)

Excellent presenter, time went quickly, appreciated the handout.

Lots of information.

Dan is a great presenter and knows his stuff.

...85% gave me a 5, 12% gave me a 4!

Room for improvement:  (I enjoyed this one) --> More VW stories

Feedback on my Understanding Explain Plan book... (March 2011)

Borjana Stojic says: Dan Hotka’s book: “Oracle SQL Tuning: A Close Look at Explain Plans” is a very useful book that helps me a lot in my every day work and it helps me a lot in understanding Explain Plans.

I worked as Oracle Developer for 5 years, and now work as Oracle DBA for 4
years.

From my experience, this is the best book about SQL tuning and Explain
Plans that I have ever read.

Hotka has a talent to explain in very simple way very difficult issues.

Dan Hotka is a great teacher and very talented teacher, too.
This is a great book!
Thank you!

Feedback from a Collaborate10 attendee... (April 2010)

Howard Hackworth says: I am a DBA and a 12 year user of Embarcadero's DBArtisan, a Toad competitor DBA tool. My new company uses TOAD exclusively and although I have been meaning to make the switch it has been a difficult transition without any training on using TOAD. Your session and now armed with your book I am
diving into TOAD and already making more headway in a day then in the past
several months without your help.

Anyway, I just wanted to say Thank You...

SQL Performance Tuning At Your Desk! (November 2009)

Galina Savikovsky says: This was the best class I ever had and the most cost-effective one. (I had a bunch of classes from Oracle itself and other providers). Dan is a great teacher and is very pleasant to work with.  I also really liked his eagerness to say good things about tools developed by other people or to give other Oracle gurus the credit they deserve.  This is a rare quality.  This class is worth every penny and every minute spent.  Thanks a lot for the great week and for the priceless information.

Feedback from a regular RMOUG attendee... (November 2009)

Robert Holland says: You are an inspiration to me...I have watched you grow and contribute to the well being of us all throughout the past 14 years of my time in the RMOUG and in every way you exemplify the lifestyle, ethics and mythos/pathos I wish to build myself. Your self-esteem is your best asset because it frees you to be
confident and powerful in your ability to give and share with others. 

In a fiercely competitive and completely over-saturated training market you have carved out an excellent career for yourself in helping others do the same.

Advanced PL/SQL At Your Desk! (November 2009)

Mike Williams says: Thanks Dan. Great class, you've done a terrific job with all of it --
material, presentation, technical details, etc.

...he later writes:

Thanks for an excellent class. When I think back over how much you
packed into 5 half-day sessions, I'm amazed. I didn't know what to
expect from a web-based class, but it was almost like having you here
providing over-the-shoulder training. I appreciate how every topic was
peppered with how-to's, useful tips on performance, comparisons with
other methods, etc. It'll take me a while to digest everything you
covered, but I can start putting this to use right away. My only regret
is that I didn't have this class years ago, as I think back over all the
code I've written that could have been so much better. I'm definitely
planning to take your other course on SQL Performance Tuning; I can't
wait to see what I've been missing in that arena! Thanks again.

Advanced PL/SQL Tips and Techniques (Denver 5/09)

I loved the code examples and snippets to take with me.  Class very well laid out.  Dan's expertise in this area is exceptional.  I have learned some useful tips.  Great stuff!  I enjoyed the course and would certainly recommend to others.

Advanced PL/SQL Tips and Techniques (Chicago 3/09)

Trainer was knowledgeable and entertaining; All around excellent instructor; Answered all questions and was very thorough; Enjoyed his examples and personality - Please bring Dan back for future classes - he is excellent!

Oracle SQL Performance Tuning Course (Ireland 2/09)

Best courseware I've ever seen!  I'll definitely pull this out as reference at work.

Why Is My Oracle10g Database is Slower than my Oracle9i Database (April 2008 - Collaborate):

Stefan Gawalewicz wrote:

Great Presentation!  Thanks

Dwain Gibson wrote:

Your class was very informative and I am glad I attended it.

Keep up the good work! Thanks.

Feedback from TOAD Tips and Techniques Course

Al Hayes recently attended my TOAD Tips and Techniques course and says: "I was generating a list of the best things I learned in the class last
night and there were quite a few. Thanks again for a good class."

Discoverer10g Tips and Techniques at RMOUG (February 2008):

Tammy O'Keefe wrote:

Thanks so much! Your presentation made RMOUG worth it for me this year.
The other stuff was just icing on the cake.

EMail reply about my quarterly Newsletter

Key Gottry says: "I enjoy your articles, especially the one in DBAzine about histograms and stats. Keep up the good work, and thanks for sharing your knowledge and experience"


Tim Castilleja says: "Thanks for keeping me on your distribution list, I've since moved into a job where I'll be using SQL Developer more and more, I appreciate the tips you offer for maximizing the use of these tools."

Greg Dora says: "Thanks for taking the time to send me your newsletter. As a 15 year Oracle DBA, now SAP (Basis) DBA new to 10g I found your information on "Tuning when no access to the code" to be right on target. "

Gorgon Lederman wrote: "Just wanted to say thanks for a great newsletter. I hadn’t realized that Oracle released an upgrade to the Trace Analyzer tool. Thanks for keeping me on the bleeding edge! "

Riyad Naser wrote:

Dear Dan;
> I would like to wish you and your family a wonderful and a happy
> holiday season. You have been a star in keeping us up to date with
> the endless fountain of tips, work arounds, and new and magical tricks
> to work with Oracle through out the year. We are looking forward to
> the new year and we all hope you'll continue to supply us with these
> nice and informative newsletters.
>
> Best wishes of a happy holiday and a wonderful new year.

Tuning When You Cannot Change the Code at Collaborate06 (April 2007):

Dwain Gibson wrote:

Hi Dan,

I attended your class entitled "Tuning SQL When You Cannot Change the
Code!" at the 2007 Collaborate conference in Las Vegas.

I thought your session was the best session I attended at the entire
conference.

Keep up the good work!

Tuning When You Cannot Change the Code at Collaborate06 (April 2006):

Tammy Harris wrote:

Excellent presentation at Collaborate 06! 

Dean Langford wrote:

I really enjoyed your session on Tuning When You Cannot Change The Code in Nashville. It was probably the most packed session that I attended, not to mention one of the most informative.

Amit Kopal wrote:

I really enjoyed your session. I actually thought that it was the best session out of everyone's I attended. 

Feedback from recent Oracle Developer10g Reports and Queries (web interface) on-site class:

Barb Hellman wrote:

BTW….Feedback on your training session was that you were the best trainer they’ve had. Good Job!!!!!

EMail about my Oracle9i Development by Example book:

Gerald King wrote:

First off, let me thank you for putting out Oracle9i development by example, I find it easy to follow, and it is helping me to understand how to use Oracle.

Reference from one client to a prospective client:

Oracle Advanced SQL Tuning Tips and Techniques  Workshop Attendees say :

• "This was a great class, if for no other reason than it's super to learn from someone who knows their stuff as well as you do!"
• "Excellent class! I liked all the examples and morals of each of them.  It really was tailored to my needs"
• "Learned a lot of interesting things, the length was good and the pace was excellent, this was good training"
• "Enjoyed the class, learned a lot.  Nice having someone who spoke in plain text instead of talking over my head.  Thank you"
• "I liked the hints for Data Warehouse/Oracle9iR2 topics"

Oracle Tuning & Troubleshooting Workshop Attendees say (Spring 2003):

• "Excellent Tips"
• "Instructor very knowledgeable"
• "Excellent Presentation Skills & a good sense of humor"
• "Good presentation and information"

Various Comments

• I clicked the link in DBAzine, which give me a treasure for tuning & new way for tuning DB. I am downloading
  your JSTuner. It must be helpful for me. Thanx in adv.

Trade Show Attendees say (RMOUG 2005, RMOUG 2004, IOUG-A 2003, ODTUG 2003, IOUG-A 2002, ODTUG 2002, Apps World 2002):

• Dan is knowledgeable about subject, delivers it well.
• Excellent.
• Fun with a dry topic.
• Dan's enthusiasm at the very end of Training Days
• Didn't drag - Never boring - Good information
  Entertaining - great speaker
• "He knows his stuff"
• "Good pace of presentation - gave me ideas"
• "Relevant to my job"
• "Very effective, interactive speaker; very knowledgeable"

Sales Managers say (Sales Manager, Quest Software, UK Office):

• "The probability of the sale closing is greatly enhanced if you have been there."
• "You definitely add value to our sales cycle."

User Group Administrators say (the gentleman wishes to remain anonymous):

• "We regularly draw about 40 attendees, we planned for 80 for your speaking appointment, and 110 showed up!"