Fantastic to see a 64-bit ETL load live on stage in Bill Gate's keynote at WinHEC. SSIS really shines in these situations: the sheer performance and scale on 64-bit is stunning, but the visual debugging and ease-of-use really make for a compelling demo, even before people start comparing us dollar-for-dollar with the competition. BillG says This is one of the clearest and neatest SQL Demos I have ever seen. Who am I to disagree?
You really should watch this (our section starts 36:00 minutes in) ... http://www.microsoft.com/events/executives/billgates.mspx
The demo was put together by Ashvini and I, but of course Ash did most of the real work to make the demo as awesome as it is. The same scenario is also running live throughout WinHEC at the AMD booth - they gave us one of the very first multicore machines available to work with - so if you get a chance to stop by you should stop to see it..
The combination of multicore procs, 64-bit processing and SSIS is going to astonish our market - I truly think that the way we lower the cost of entry to high-performance ETL will change the way people think about data warehousing in their organizations.
Enjoy the video - and thanks to Ash, Francois (who demos on stage) and the great guys from AMD.