Here’s a great checklist for a BizTalk Adminstrator to install BizTalk: http://biztalkadmin.com/setting-up-a-new-biztalk-2010-environment/?goback=.gde_1893939_member_224699608 by Tord Glad Nordahl  

Today, I recycled one of my host instances, and it didn’t start. Then I tried all of them, and several had issues. Finally, it dawned on me that I had changed the 64-bit config file: “c:Program Files (x86)Microsoft BizTalk Server 2010BTSNTSvc64.exe.config”. The 32-bit host-instances were all starting fine, because it uses a different config file […]

— MSSQL Server string to date conversion – datetime string format sql server — MSSQL string to datetime conversion – convert char to date sql server SELECT convert(datetime, ‘Oct 23 2012 11:01AM’, 100) — mon dd yyyy hh:mmAM (or PM) SELECT convert(datetime, ‘Oct 23 2012 11:01AM’) — 2012-10-23 11:01:00.000 — Without century (yy) string date […]

We have one table with about 120 columns in it. I was just curious what the average row size was, and found this slick solution: Use DBCC to find the “Average Size of a Row” Syntax: dbcc showcontig (‘your_table_name‘) with tableresults My tablename=’Transaction’, so substitute your tablename there. Example: dbcc showcontig (‘Transaction’) with tableresults Enlarged: […]

Below is a code fragment I use to extract a matching string using RegEx (C# Regular Expression). I put it in a class library, and make it available to BizTalk Orchestrations, Pipeline, and Map Scripting functoids that might need to call it. <pre> //using System.Text.RegularExpressions;  <– put this above your class, put the method below in […]

Error: Failed to load Group xxxx.BizTalkMgmtDb] data providers (in BTSAdmin Console) Solution: Verify SQL Server is available, if not, start-it. Screen shot below shows trying to connect to the SQL server; it might be on the same machine as BizTalk or it might be on another machine. The above error could also indicate a communication […]

I cannot count how many times I have got the error below: It typically happens when you try to import a BizTalk MSI application fro, one machine and export it to another. What it implies is that that system you have exported from, and the system to which you are importing, having different settings on […]

Using the following Reg-Ex (Regular Expression) to find UTF-8 or UTF-16 characters in a text file; this should work with any editor that supports Reg-Ex, such as NotePad++ or Visual Studio. Be sure and check the “Regular Expression” option on the search, then type in the find string: [x80-xFF]