SingingSQL is the banner for Dan Tow, author of SQL Tuning, the authoritative text on the subject.
- 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.
presented my class, Top-Down SQL Tuning, soon, July 24-25, 2008 in Palo Alto.
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.
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).
Already-published newsletters: 2006-Q1, Featuring "Performance and Tuning, the Big Picture"
2006-Q2, "Killing Cache Efficiency with Parallel Table Rebuilds" and "Hard 'Overlap-Query' Problems"
2006-Q3, "Shortcuts for Gathering Tuning Stats Quickly"
2006-Q4, "Extending the Diagram Method for a Special Case"
2007-Q1, "Remote Links Case Study, with a 3000-Fold Speedup"
2007-Q2&Q3, "Why Nested Loops Win So Often"
2008-H1, "Views, from Forty-Thousand Feet"
2008-H2, "Digging Deeper and the Dangers of Procedural Thinking" and "More about the Big Picture"
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 dont 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,
This will reduce database parsing, or This will reduce IO contention.