Two new whitepapers have recently been authored and will be posted to MSDN shortly. These are full of key information on the primary issues customers may face when using the SQL and SOAP adapters with BizTalk Server.
They can be found at: http://msdn2.microsoft.com/en-us/biztalk/aa937652.aspx.
Best Practices for the SQL Adapter
Sample Design Patterns for Consuming and Exposing Web Services from an Orchestration
Kudos to our fantastic Support Engineers who continue to publish relevant content back to our customer base!