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

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.

Continue reading about Testing Framework for ETL

Shane on November 2nd, 2006

This excellent piece in DMReview deliberates on some criteria for selecting (or justifying) an ETL tool. We are struggling with this right now. Our shop uses a combination of Informatica and SQL Server DTS for our ETL jobs. With Oracle Warehouse Builder 10gR2 and SQL Server Integration Services both released as viable alternatives, we need [...]

Continue reading about Why Do We Use Informatica?

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

Shane on May 24th, 2006

I scan a handful of financial blogs pretty regularly. I also scan a handful of technical blogs relating to SQL Server and Oracle. It isn’t very often that a blog from one of these worlds links to a blog in the other. But here’s JLP from AllFinancialMatters linking to Don Burleson of fame. I [...]

Continue reading about Two Worlds Collide

Shane on April 12th, 2006

Since the PeopleSoft table naming convention is to use as many underscores as possible, I’ve run into many snafus since the underscore is a special character in SQL. Clark (via Linda) showed us some ways around this. select count(*) from dba_tables where table_name like ‘%\_UM’ escape ‘\’ COUNT(*) ———- 113 1 row selected This query, [...]

Continue reading about Special SQL Characters