Sep 20
WCF-SQL – UseAmbient Error
This blog describes an error that you might see if you are using the BizTalk WCF-SQL adapter to insert data into a SQL Always Database Use case In
Aug 23
BizTalk360 – BRE Policies not in a deployed State
This article shows how to use BizTalk360 to alert when there are no BRE policies in a deployed state Use Case Sometimes after a deployment to BizTalk
Jul 9
Azure SQL Data Sync – My Story
This is a story about my experiences using Azure SQL Data Sync You will learn how to use this to migrate a custom on-premise database to Azure Azure
Feb 25
BizTalk360 – Secure SQL Queries
This post talks about using Secure SQL Queries in BizTalk360 To demonstrate I walk though a scenario that shows how to expose BizTalk data to users safely
Mar 4
Moving SQL 2016 BizTalk Databases that are in Availability Groups
Last week I had to move some databases quickly from one SQL server environment to another Traditionally you would have built your new SQL servers, backup and
Aug 19
Can I use a BizTalk WCF-SQL send adapter with a SQL 2012 Always on Database?
I think the answer is no unless you are prepared to accept the risk of duplicates and/or lost messages Let me explain why below This is a summary of
Mar 2
A nice piece of recursive SQL – Split a delimited string into separate records
I was trying to break a delimited string down today in to a separate record for each delimited value and came across this gem that uses
Apr 12
Query notification and the BizTalk WCF SQL Adapter: Comments and unresolved questions
I work with a architect who has an obsession about not allowing BizTalk to poll SQL servers We have tried many times to cure their disorder One of the
Mar 22
Should the WCF-SQL adapter be used in low latency scenarios?
I recently outlined a low latency solution using BizTalk 2010 where the response had to return in less than 1 second 99% of the time The solution was tested
