Tag Archives: SQL

Azure SQL Database Timeout Exceptions

I had came across an issue were the Azure database was throwing timeout exceptions like the one below when under heavy load. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. … Continue reading

Posted in Azure | Tagged , | Leave a comment

Using SQL2008 Data Table Type & BizTalk to insert parent-child rows

I wanted a way to insert a parent row with multiple child rows in one single transaction into a database using BizTalk 2010. The solution I came up with uses the table data type in SQL 2008 to insert parent-child … Continue reading

Posted in Biztalk | Tagged , , , | 5 Comments