This overview article at the SQL Server Developer Center provides a nice & quick rundown of new features for database development in Microsoft SQL Server 2005.