Aldrich Blog

C# | BizTalk

BizTalk Database Maintenance

Out of the box, BizTalk Server 2006 doesn't provide any tool for auto clearing and cleaning up database used by BizTalk, this cause problems like performance and data storage issues. While browsing BizTalk installation directory (\BizTalk Installation Folder\Schema) I've found out few sql scripts that can used to cleanup the MessageBox = BizTalkMsgBoxDb and Tracking = BizTalkDTADb database. Read more →

BizTalk Server 2006 Prerequisite

Link can be found below:   Legacy Comments sayyed 2007-06-27 re: BizTalk Server 2006 Prerequisite hello i very much intersted on ur site is vey good ram 2007-07-13 re: BizTalk Server 2006 Prerequisite kjojojo chandra 2007-07-19 re: BizTalk Server 2006 Prerequisite I wnat ot see Read more →


Microsoft recently released the v. 1.0 of ASP.NET AJAX "Atlas" and I've attended a demo about Atlas and find it really cool. Just simple drag and drop, cut and paste viola. Read more →

BizTalk Database Customization

One of the problems we face during the development of BizTalk Application is that lack of space in the main drive C:\, Since we do default installation for MSSQL and BizTalk 2004, the Data File and Log Files is of course is installed in C:\Program Files\Microsoft SQL Server\MSSQL\Data. Read more →

Pagination using Stored Procedure

There are different approach on how to do pagination, but the I personally uses the dynamic sql pagination using subquery, and this I think is very efficient when doing a pagination in which all the fields to be filtered and sorted are all in the same table: Read more →