The Microsoft SQL Server 2008 Management Studio will provide T-SQL Intellisense. Let the party begin :)
The speakers for the Microsoft Sync Framework, ADO.NET Data Services, and SQL Server Data Services mentioned the one-two punch you get from leveraging these services together. SQL Server Data Services is a web facing data storage and processing utility to be launched by Microsoft during the first-half of 2009...
SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces...
Another release mentioned at TechEd 2007. SQL Server 2008 June CTP with a bunch of new features...