SQL Server 2008 – Will new features be leveraged in TRIM Context and SharePoint?

With the upcoming release of SQL Server 2008 (aka; Katmai) during the 3rd quarter of 2008, Microsoft seem to be working hard on delivering some cool functionality with the new database management system.  With reference to some of the information management products that I work with; namely TRIM Context and SharePoint, I see vast potential for improvement in these products while leveraging new SQL Server 2008 features.

A couple of new features that really excite me with respect to TRIM and SharePoint are:

1. The addition of the FILESTREAM data type in Katmai that will contain both structured and semi-structured data. This means that structured meta-data about the file is stored in the database itself, while the semi-structured BLOB data  resides on the NTFS file system. With SharePoint 2007, I never really understood why Microsoft elected to place files in a relational database rather than on an NTFS volume (built in the very first place to optimise streaming). Anyway, the point is that when the database is backed up, referenced files on the NTFS volume are backed up as well. T-SQL and Win32 API’s can now be used to access files seamlessly. I would think that Microsoft would be keen to leverage this feature in SharePoint 2009.
2. TRIM Record Locations are a reference to a physical or abstract existence of a body of information. Therefore a record location in TRIM could point to a person who owns the body of information or a shelf location where the body of information resides (eg; a book in a library). With the introduction of new spatial data types GEOMETRY AND GEOGRAPHY in Katmai, planar (flat-earth) and ellipsoidal (round-earth) data can be represented in SQL Server 2008 seamlessly. It would be a pity not to see Tower Software and HP ignoring to extend the Record Location TRIM concept to use the new spatial data types as this would be extremely applicable to the records world and several key industry verticals including State and Federal Department, Asset Tracking and Asset Management and auto-allocation.
3. The Change Data Capture feature being introduced in Katmai could be leveraged extensively within both TRIM and SharePoint.The Change Data Capture feature provides the ability to capture what has changed in a database structure as a steady stream. While this push-model could not only provide OLTP -> OLAP integration for both products, current capabilities of the products with respect to retention and auditing could be vastly improved.