Whenever I do a webcast or presentation, I always ask the audience to indicate where their organization is in relation to running SQL Server 2000 or running SQL 2005.  Recently, in an audience of about 40 people, more than half of the audience still had more than 50% of their production servers running SQL Server 2000.  One of the ...

If you have systems that are stil on SQL Server 2000 and that you are preparing for SQL Server 2005, run the Upgrade Avisor for SQl Server 2008 as well.  So, while you are under the hood of your database and app getting it ready for 2005, get it ready for 2008 too.  There are a lot of new features in 2008, but nothing that was taken away ...