SQL Tuning Services

 
 
 

SingingSQL is the banner for Dan Tow, author of SQL Tuning, the authoritative text on the subject.

Prime offerings:

  • Performance and tuning classes – I teach what I know, with focused classes at your site – want to do it yourself? If you want to learn SQL tuning from the guy who wrote the book, I offer a successful class based on the book, offered at reasonable rates onsite at your company! Here's the course outline.

  • SQL tuning – I tune problem queries fast, usually in minutes.

  • Problem SQL analysis – I find which SQL should be tuned, systematically and automatically.

  • Design for performance – I help design and modify databases for robust application development with data integrity, without sacrificing performance.

  • Database/system configuration – I tune database and system configurations.

  • Big-picture performance analysis and problem resolution – performance problems outside the database? – I find them and fix them.

  • Ongoing performance maintenance – I offer periodic planned analyses to find and fix new problems that might arise after the initial round of analysis and repair.
SingingSQL News
  • I presented my class, Top-Down SQL Tuning, soon, July 24-25, 2008 in Palo Alto.
  • I presented SQL Tuning, Reaching Recent Data Fast, with whitepaper, at the Northern California OUG (NoCOUG) in November 2008.
  • I will present my new seminar, Safe Use of Views? Just Say "No"? at the HOTSOS Symposium sometime between March 9 and 11, 2009.
  • I invented a new puzzle, a challenging variation on Sudoku, with new puzzles published daily online on my new website - check it out: Suduro.
Why are you here?
    I want to offer you something more for coming to the site than just a brochure for my services: Tuning Scripts! These are Oracle SQL scripts, (with README use instructions) that I use many times/day, almost every day! I frankly spend too much time tuning SQL and teaching SQL tuning to offer a rapidly changing site with regular new blogs, but if you'd like to sign up for my informal email newsletter that offers articles, tips, and announcements of coming classes 2-4 times per year, go to Contact and drop me a line requesting free membership in my subscriber's list. Also, please drop me a line if you want to be notified specifically of classes and seminars in your area (which you may specify).
    Accumulated Newsletter features: News of past and coming SingingSQL events
    Links to externally published articles and presentations
    Proposed research problems

     

    The SingingSQL approach:

      If you want endless meetings and tedious reports of a hundred or more “problems” that might slow your application by some unknown (usually miniscule) amount, with vague or unrealistic solutions to those problems, I suggest you use other, larger consulting services.

      If you want rapid (often one day of work or less), realistic solutions to just the few problems that matter, with scientific predictions of how much those solutions will help your business, I am the answer! I don’t guess, I measure, and I translate improvements into terms of the economic benefit to your business –

      “This will save your end-users 3 hours/day that they currently waste waiting for the hour-glass to turn,” or “This will buy you room for 25% more business growth before you need to buy more hardware

      NOT

      “This will reduce database parsing,” or “This will reduce IO contention

      Contact

     

 
 
 


©2002 SingingSQL All rights reserved