A group I’m working with was looking to use SharePoint to capture data entered by a number of international employees. They asked if SharePoint could restrict access to a given list item based on the value in a particular column. So, if the user created a line item designated for “Germany”, then automatically, the list […]
Yet more great content over on the (RedGate sponsored) Simple Talk blog, this time an excellent article on tracking down deadlocks using SQL Profiler by Brad McGhee, well worth a read before your production system starts to exhibit this behaviour!
Hi All,
In the past few months I been hit with so many technical problems running biztalk 24 * 7.com. I’m currently with 1and1 for my hosting, I been with them for past few years now. Everything is well and good until you hit a problem, but once you got some you are in real trouble.
In my past few months experience I never got a single issue solved by their technical team (this is just my experience).
At last I decided to take the plunge and move to a different hosting company. That’s the only way I can come with next version of biztalk 24 * 7 confidently. Now I need your help on making my decision, here are my criteria’s
1. Preferably in UK, since it will help me solve the issue during UK office hours. With 1and1, even though I’m a UK customer their server department is in US and most of the time I simply need to wait until US wakes up.
2. Windows Server 2003 virtual or dedicated sever hosting.
3. Support for ASP.NET 2.0 and SQL Server
I’m sure lot of you out there reading my blog will have experience in this area. Please feel free to drop your comments.
Nandri!
Saravana
We’ve had a recent deployment to production that did not go according to plan, or so we thought at first.It is an upgrade of aBizTalk solution from BizTalk 2004 to 2006 R2. It integrates a website, a CRM system, a bank system, and a fulfillment house.
We deployed the solution to our test environment, fixed some […]
Thanks to all who attended my talk on VSX & Software Factories at VBUGlast week. It was a decent turnout considering the last minute change of venue. The slides should be available from Chris Mitchell at VBUG and I’m also posting them here on this blog for anyone else who is interested in the topic.
As […]
Assume you’re using the WCF SQL Adapter (part of the BizTalk Adapter Pack 2.0). You decide to create 2 Receive Locations (RL), in order to poll the database. Each RL polls a different table (e.g., the “PollingStatement” binding property in the first RL is “SELECT * FROM T1”, while the “PollingStatement” binding property in the second RL is “SELECT * FROM T2”).
Since the tables are present in the same database on the same SQL Server instance, the URI which you enter is the same in both RLs (e.g., something like “mssql://servername/instancename/databasename”).
However, BizTalk doesn’t allow you to create multiple RLs in the same BizTalk application with the same URI. From the BizTalk point of view, it’s like having 2 RLs competing in the same BizTalk application for the same incoming messages. Even though in this (the WCF SQL Adapter) case, both RLs are pulling in messages from different sources (the “PollingStatement” controlling the message source).
There is a pretty simple workaround for this. You can use the following (different) URIs in each ReceiveLocation:
“mssql://servername/instancename/databasename?SomeUnusedQueryParameter=1”
“mssql://servername/instancename/databasename?SomeUnusedQueryParameter=2”
“mssql://servername/instancename/databasename?SomeUnusedQueryParameter=etc”
That some spammer thought my wiki pages where hit enough to warrant modifying them
on a daily basis with links to various “odd” sites 😉
Thanks to Craig I’ve
upgraded to FlexWiki 2.0 and now those pages
are locked down – I apologize if you’ve visited them and they haven’t been right,
should be ok from now on.
Check out my BizTalk
R2 Training.
When we make changes to our BizTalk environments, we always ensure that the changes are scripted so the Ops Team don’t really need worry about messing things up – as a result, we use Binding files everywhere. Normally, we do large scale solution deployments, but earlier this week we needed to update the subscription filter […]
On my previous MSDN WebCast I showed a demo of how to use a custom WCF protocol channel to combine Workflow Services and durable messaging transports channels like MSMQ. If you watch the recording of the WebCast you can see the entire demo, but there…(read more)
Thanks to everybody who attended to my MSDN WebCast about WCF-WF integration in depth . You can watch the recording here and the samples are available for download here ….(read more)