I have been reading through BizTalk 2010 Technical Review and noticed that a few things have been changed in BizTalk 2010 compared to current 2009 version. SQL Adapter has been removed and one should now turn to WCF-SQL Adapter that is a part of BizTalk Adapter Pack 2.0. Although in my BizTalk Server 2010 Beta environment on VPC, I still see the SQL Adapter.
In forums I notice still a lot of people use the standard out-of-the box SQL Adapter and they will have to make the shift towards WCF-SQL Adapter in future.For anyone who likes wants to learn more, the article on Packt Publishing by Richard Seroter called New SOA Capabilities in BizTalk Server 2009: WCF SQL Server Adapter is a good starting point and as a follow up my previous post WCF-SQL Table Operations discusses how to set it up the adapter and how CRUD operations on tables in SQL Server work.
Another change is that BizTalk Explorer tool in Visual Studio 2010 is not available for BizTalk Server 2010. Any administrative task you as an administrator of developer wants to do with a Graphical UI is BizTalk Server Administration Console. I think a lot of people stop using this feature in 2006 as Administrative Console came available.
In the Administration console you will also find the BizTalk Server Settings Dashboard, and this is a new feature. Performance settings previously managed through the registry and other locations, are now been centralized in this dashboard. To manage settings (i.e. performance) for the group, hosts, and host instances, you can now use this dashboard. These settings control throttling, thresholds and other runtime parameters in a single location and all settings can be exported and imported to move them between environments. Thiago has written an excellent post on this called BizTalk Server 2010 Beta: Settings Dashboard and Latency control per host.