Visual Studio 2008 and SQL Server 2008 Integration

Consider this a pre-post...  I received a lot of questions in regards to the integration of VS 2008 and SQL 2008.  As of the current date SQL 2008 was just released as a CTP while VS 2008 has already be made publically available.  The main things that folks are realizing is the lack of SQL 2008 project templates in VS2008 as well a database validation and other DB Pro tools in support of SQL 2008.  I will post a link to some workaround information that should be available on MSDN shortly, but note that this integration "IS" coming... an update to Visual Studio 2008 will be available in conjunction with SQL 2008 when it ships, if not sooner.