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, November 2nd, 2006

Testing Framework for ETL

The holy grail of a former .NET web developer is how to combine the techniques of agile and test-driven development with ETL tools and data volumes. Mark Rittman shows that he is a brother-in-arms with my quest.

No Comments » - Posted in Informatica, Oracle, SQL Server by Shane

Thursday, November 2nd, 2006

Office Anthropology 101 by Alan Alda

Rule number two of blogging is to title your posts after search terms people might use on Google. I’m sure this title will get a lot of traffic. (Rule number one, by the way, is to write a lot.)
Anyway, Margy Ross and Ralph Kimball write an interesting article about interviewing customers during the analysis [...]

No Comments » - Posted in Uncategorized 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