MSDN TV: Introduction to Analysis Services 2005

I watched this demo and it is really impressive how quicky analysis cubes can be created and consumed in SQL Server 2005. I haven't had the opportunity to use analysis services with SQL Server 2000, so I can't appreciate how much easier it is in 2005. However, the benefits of cubed data become apparent pretty quickly while watching this short demo.

MSDN TV: Introduction to Analysis Services 2005

SQL Server Query Performance Tuning

This article on SQL Server Query performance tuning appears to be very useful. Something to have in the toolbox.

http://www.sql-server-performance.com/statistics_io_time.asp

Create Data Insert Scripts

This link is to a stored proc that will create Insert scripts for all of the data in a sql server table. A useful little bugger...

http://vyaskn.tripod.com/code/generate_inserts.txt