December 2014 – Page 2

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

December 17, 2014 at 4:15 pm (last edited December 17, 2014 at 4:31 pm)

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

1421 Admin

December 15, 2014 at 9:29 pm (last edited December 15, 2014 at 9:42 pm)

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 […]