Archive for February, 2010

IT-Efficiency: Things to check during your coffee break – BizTalk MBT (2010-2-17)

Co-author: Jeroen Kooiman (Unisys) Most people prefer to handle BizTalk as a Black-box and don’t have a clue of what’s going on (or don’t want to ) inside the SQL databases. The overall performance of BizTalk very much depends on the performance of its databases, managed by SQL Server. As BizTalk operations are asynchronous processes […]

Speeding Up SSIS Bulk Inserts into SQL Server (2010-2-5)

Since we set the ETL World Record  with the introduction of SQL2008, a lot of insights, tips & tricks have been published on what it takes to load data fast into SQL (see also the Data loading Performance Guide). The trick described below is one to remember if you are being challenged to load a […]