It is time to continue the BizTalk Community Series after a recent successful event in Norway, the Bouvet BizTalk Innovation Day. This event was a great opportunity for me to meet up with many Scandinavian BizTalk professionals.
During the two day event we as BizTalkCrew, Kent Weare and Paolo Salvatori (Microsoft) presented about the latest (Windows Azure BizTalk Services, BizTalk 2013), proven
I found a great article about comparison between BizTalk Server and BizTalk service on codit I have given quite some sessions and presentations recently on Windows Azure BizTalk Services. We had the opportunity to work together with the product team on WABS as a strategic Launch Partner. I had a lot of discussions and questions […]
Blog Post by: Jeremy Ronk
This blog post gives a feature comparison between Windows Azure BizTalk Services and BizTalk Server.
One of my clients wanted to know how many messages were processed on a certain BizTalk port.
To show some statistics, I created a SQL query that lists a message count of the messages processed per hour for a certain Port.
Here’s the SQL query I used:
use BizTalkDTAdb
SELECT top 200
a.[Event/Direction],
a.[Event/Port],
CONVERT(VARCHAR(10), a.[Event/Timestamp], 111) as [date],
DATEPART(HOUR,a.[Event/Timestamp]) as [Hour],
COUNT(*) as [Count]
FROM [dbo].[dtav_MessageFacts] a
inner join dbo.btsv_Tracking_Parts b on a.[MessageInstance/InstanceID] = b.uidMessageID
WHERE a.[Event/Port] <> 'PortSqlMonitor'
AND a.[Event/Port] = 'BizTalkPort'
AND a.[Event/Direction] = 'Receive'
AND a.[Event/Timestamp] > DATEADD(day, -3,GETDATE())
GROUP by a.[Event/Port], CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp]), a.[Event/Direction]
ORDER BY CONVERT(VARCHAR(10), a.[Event/Timestamp], 111), DATEPART(HOUR,a.[Event/Timestamp])
I have been trying to complete the “Using BizTalk Service Bridges to Send and Receive Messages from Service Bus Relay Service” tutorial and I kept on getting this error in Step1: Build and Deploy the Relay services. Whenever i try to run RelayReceiverServiceA.exe 2 <ServiceBusNamespace> owner <Issuerkey> /RelayReceiverServiceA from the command line the relay does […]
Blog Post by: mbrimble
I received an email in the early hours of this morning right when Arsenal just slotted
one home in the Champions Leagueand I thought”Can this moment get any better?” –
YOU BET! My MVP re-award email came through 🙂
Big thanks to the folks at Microsoft for bestowing this award to me again (9th year
running) and being given the chance to be part of a great knowledgeable MVP community.
The real thanks goes to you guys in the community of which I try to make a difference
in the Azure Space. With cloud offerings changing every other week (it feels like),
it’s almost a full time job keeping on top of things. New numbers, bigger limits,
faster storage, different ways to manage traffic, connections, deployments, code platforms
and the list goes on.
Thanks to each and all of you for making this award possible in this great country
– Australia (down under, Oz and any other name you know it as)
Boom!!
or as a friend says ’Ka-Boom!’
Blog Post by: Mick Badran
I got this error when I attempted to deploy the second tutorial , “Using Azure BizTalk Bridges to Insert Flat File Messages into an On-premises SQL server”. I had successfully completed the first tutorial after dealing with some deployment errors here and was on a roll but got stuck on this sucker. The full deployment […]
Blog Post by: mbrimble
I dislike visual clutter. Most people do. Perhaps they can’t articulate it. I know most of our clients say things like, “It looks too crowded,” if presented with something that strikes them that way. They don’t use the words “visual clutter” as we would in design parlance.
However, that idea of clutter-reduction has recently over-reached it […]
Blog Post by: Krish Mandal
While search for some MS Events – I gravitated towards
https://msevents.microsoft.com and boom!
I recognise her and her and me!
(there’s my hand in there)
Blog Post by: Mick Badran
In September, my employer Tier 3 rented a house in St. George, Utah so that the Engineering team could cohabitate and collaborate. The house could accommodate 25 people, and we had anywhere from 8-12 folks there on a given week. This was the first time we’ve done this, and the concept seems to be gaining […]
Blog Post by: Richard Seroter