Find out how many rows of each table in your BizTalk Databases

Sometimes one of your databases is eating up diskspace, and you want to know why.  By running the query below, you can easily view the number of rows for each table (and can even sort so that the tables with the most rows are on top). USE BizTalkDTADb –USE BizTalkMgmtDb SELECT sc.name +'.'+ ta.name TableName […]

Get AppSettings Config Value in a Biztalk Functoid

Normally, I would call a static method in a C# library rather than coding this in a functoid. It’s easier to unit test, you get full Intellisense (automatic code completion), and it just seems easier. However, I’m at a new client, that doesn’t yet have a C# library. It’s really no big deal to add […]