Tag Archives: SQL Server

Using the ExecuteReader Operation of the BizTalk Adapter for SQL Server

Earlier this week I participated in a discussion thread on LinkedIn regarding the usage of the WCF SQL Adapter in BizTalk Server and I wanted to summarize some of my thoughts and the recommended best practices regarding this particular scenario.

Continue reading

Posted in System Integration | Tagged , , , , ,

Practical Applications of BizTalk Server, Windows Workflow and SQL Server Integration Services

In an effort to maintain control over the proliferation of application servers and data, many organizations have undertaken projects to consolidate and integrate systems. One of the first hurdles in undertaking an integration project is determining the most efficient integration technology. Unfortunately, just within the Microsoft stack, there are technologies that consistently cause confusion and are often misused.

Continue reading

Posted in System Integration | Tagged , , , ,