In an interview with Gert Drapers , SQLCMD was mentioned as SQL Server 2005's Easter Egg (Gert: "one of the biggest productivity gains for DBA’s in terms of automation"). I hope that I can pull this feature somewhat out of obscurity :-) Watch the SQL...

Table and Index partitioning is one if the new SQL Server 2005 features that willl improve life for the DBA and application developer quite a bit. It allows Indexes and Tables to be partitioned across multiple file groups. Partitioned tables and indexes...

I just finished the Scripting in Microsoft SQL Server 2005 webcast. Thanks all for being online (and also thank you MVP's for answering questions!) I was a little nervous doing this (it's a big deck with lots of demos) but I think it went quite OK...