• One big item the author missed was SQL 2008 Filestream. Instead of filling your DB with images, etc... you can use FileStream to map these images through the DB. They can live on a file system instead of in your DB. Apparently this functionality has existed in Oracle and Microsoft has finally caught on. This is especially useful for web-based DB's where you can reference all kind of backend files.

    There seems to be a debate about whether filling your DB with things like images is a good idea. Just because you can put all kinds of stuff in your DB, is it a good idea?

    http://blogs.msdn.com/pedram/archive/2007/06/04/store-any-data-in-sql-server-2008-katmai.aspx