Shane on November 2nd, 2006

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

Continue reading about Michael Ault on SQL Tuning

Shane on October 12th, 2006

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 [...]

Continue reading about Scaling to Infinity Seminar

Shane on June 27th, 2006

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 [...]

Continue reading about PowerExchange Throughput