Damn fine blog.
Exploration Through Example

Will eventually be using Nant for deployment, Scott Colestock seems to have most of the issues thought out, paste that for reference!

Trace of Thought (Scott Colestock) - BizTalk 2004 "Deploy with Nant" Template Revamp

A new blog entry that may be useful.
Constructing BizTalk 2004 XML Messages (In an Orchestration) - Choices

Adapter Source
I will be using the SFTP adapter from /N Software soon, I'll do a full report on my findings once finsihed. Stay tuned!

/n software inc - The Leading Provider of Internet Components

We are having concurrency issues with a third party application. Seems the application developers knew about concurent updates and locking issues, but some of their code doesn't use locking hints to limit to single rows. Especially when they inserting a new object level record (inserts single row in all tables). Needless to say they were asking for this kind of trouble when developing such a highly non-normalized data structure, that is another blog entry or two.

Sequential convoy pattern is actually simple to impliment if you are familiar with how subscriptions work, and can decide on what uniquely identifies the group of messages you wish to correlate. I used this pattern and am correlating to the receive location, almost seems like cheating doesn't it?

Sequential Convoy Aggregator Pattern in BizTalk Server 2004