There are 8 tables in each BizTalk Message Box database which store the tracking data before it is imported by the BAM EventBus Service (a.k.a. TDDS or Tracking Data Decoding Service) into the DTA/HAT and the BAM Primary Import databases. The tables are...

Download it from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D20B4510-E5A6-4D7B-87A1-4BD52BDD57B8&displaylang=en

I'm putting this here so that I don't forget where to look for it later when I need it as it has already happened in the past. Mike has a great post which is full of links to other great posts on the topic.

"... It seems that the DTS/SSIS package BAM_DM_<activity name> should be moving it into the Instance and Relationship tables in the BAM Archive database but it doesn’t." The BAM Data Maintenance DTS/SSIS package will only move data that is out...

I meant to post this earier so you might have already seen it but here it is. A short FAQ covering common questions and a document on using the BAM APIs.

I get different flavors of this question a lot so I’ll put some Q&A here. Q. Is there a way to view the data stored in the BAM Archive database in the BAM Portal? A. The short answer is NO. The BAM Archive database is the final destination for...

DISCLAIMER -- The bts_CleanupMsgbox stored procedure IS NOT SUPPORTED. IT IS NOT TO BE USED ON PRODUCTION SYSTEMS!!! The steps to workaround the bts_CleanupMsgbox issue outlined below ARE NOT TO BE USED ON PRODUCTION SYSTEMS!!! You can use bts_CleanupMsgbox...

This is an issue I see every once in while so let's see what causes it and how to diagnose and fix it. You have created and deployed a BAM definition with some BAM views in it but when you hit the BAM Portal with IE all you see in the "My Views" pane...

You can find some orchestrations code samples and FAQ at the BizTalk Developer Center . And the cool virtual lab at the BizTalk TechCenter . Learn what's new in BAM in BizTalk Server 2006.

After spending some time to find out that there is no easy way to drop all indexes from a SQL table I came up with this script. DECLARE @indexName NVARCHAR(128) DECLARE @dropIndexSql NVARCHAR(4000) DECLARE tableIndexes CURSOR FOR SELECT name FROM sysindexes...

As some of you already know Microsoft BizTalk Server 2006 has been available for some time now. Visit http://www.microsoft.com/biztalk/evaluation/bts2006beta.mspx for overview of the changes and instructions on how to get the beta. And don't forget...

Gilles started a series on the new BAM Portal. Scott Woodgate is presenting the new features and improvements in BizTalk Server 2006. See what he has to say about BAM .

I’m really exited about all the great new features that we’ve put in BAM in BizTalk Server 2006 but I figured out that we’ve made some changes to the bm.exe commands and you need to get familiar with those changes before everything else. The information...

If you enjoy being a part of this year's Microsoft TechEd and if you work in the Information Worker space make sure you visit the Business Activity Monitoring (BAM) hands on lab for a glimpse on some of the new features which will be part of Biz Talk...

Here is a good summary on Indigo .

You want to feel the Indigo ambience? Don Box will walk you through the hallways of the platform for the next generation of distributed systems. COM fans are also welcome. http://channel9.msdn.com/ShowPost.aspx?PostID=18088 Watch for the Bob’s performance...

Have you ever wondered how to get the DNS domain of the machine from a Windows batch file? Well, I needed it and after some investigation I found the USERDNSDOMAIN environment variable and I was happy. echo %USERDNSDOMAIN% Until yesterday, when...

Brad Abrams on volatile and MemoryBarrier() . Someone sent this to the team and I couldn’t stop myself from reading it. If you use the double check locking pattern, then most probably you are already aware of the pitfalls in it. Using volatile...

Almost one month after creating my blog I finally found some time to spend one-on-one with Word and wrap up my introduction posting. As you can easily guess I work for Microsoft and I will share with you my thoughts on the craft of software development...