One of my favourite aspects of SQL Server 2008 is the fact that you can store documents (well, files) in the database. Annoyingly, this doesn’t seem to be implemented in the June 2007 CTP.
There has long been an argument about whether images should be stored in the database or in the file system. The same argument occurs when discussing Word documents, Excel spreadsheets, and all the rest. With SQL Server 2008, the answer is simple – store in the database using a varchar(max)/nvarchar(max)/varbinary(max) type with the FILESYSTEM option. This will store the information in the file system, but still let you manipulate the data using standard constructs like UPDATE and DELETE. Very cool! Now people can access your data through whichever medium they need.