Thursday, November 2nd, 2006
Michael Ault on SQL Tuning
I didn’t get a chance to catch Michael Ault’s presentation at the recent TCOUG, but I heard it was a good talk. Thank you Michael for putting the slides online.
SQL Tuning 101
Development Techniques for Data Warehouses
No Comments » - Posted in Oracle by Shane
Thursday, October 12th, 2006
Scaling to Infinity Seminar
I went to a seminar on Oracle partitioning and data warehousing earlier this week call “Scaling to Infinity” by Tim Gorman. It gave me some new ideas, and reinforced some others, for where we should take our architecture at the U.
Here are some notes that I will hopefully talk more about as I research them.
Functions [...]
No Comments » - Posted in Oracle by Shane
Tuesday, June 27th, 2006
PowerExchange Throughput
I got a question about PowerExchange throughput the other day. When we were first evaluating PowerExchange as a solution, this was a primary concern of ours. We devoted hundreds of hours designing, implementing, and refining a good test of our throughput. In the end, we over-tested. The throughputs that we dealt with in the test [...]