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

By Mark Brimble

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

By Mark Brimble

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

By Mark Brimble

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

By Mark Brimble

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

By Mark Brimble
Feature blog image

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

By Mark Brimble
Feature blog image

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

By Mark Brimble
Feature blog image

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

By Mark Brimble
Feature blog image

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

By Mark Brimble
turbo360

Back to Top