Microsoft has released documentation describing how to integrate MOSS 2007 with SQL 2008 to enable the usage of SQL 2008 features like

• Database backup compression
• Log stream compression 
• TDE (transparent data encryption)

Integration of SQL Server 2008 and Office SharePoint Server 2007