by community-syndication | Feb 17, 2011 | BizTalk Community Blogs via Syndication
This week Microsoft is hosting the first edition of their annual TechReady conference. Even though TechReady is an internal conference, Microsoft invited us to present a not one but two sessions about some our recent work. We are particularly proud of…(read more)
by community-syndication | Feb 17, 2011 | BizTalk Community Blogs via Syndication
I had a requirement to map a buyer only if it was the same buyer throughout the entire document. The reason for this was that in the source document the buyer was defined in a sub sub sub note of a document and in the destination it occurred only once…(read more)
by stephen-w-thomas | Feb 17, 2011 | Stephen's BizTalk and Integration Blog
Our book, Applied Architecture Patterns on the Microsoft Platform: An In-Depth Scenario-Driven Approach to Architecting Systems using Microsoft Technologies, is now available in India at a significant discount for orders placed and delivered in India! This type of discount is common with most technology books due to the difference in costs and wages in India vs. US and Europe.
Computer Bookshop is offering our book for 400 Rs (20% the normal price of 500 Rs). The direct link is: http://www.cb-india.com/Detail.aspx?prodId=16113&catid=777 Shipping varies by destination.
If you live in India, this is a great chance to get a copy of our book.
If you live in the US, our book is still available on Amazon.com using the link below.
Do not forget that anyone can download all the sample code for the book here: https://www.biztalkgurus.com/media/p/30260.aspx
by community-syndication | Feb 16, 2011 | BizTalk Community Blogs via Syndication
When applications / systems integrate with BizTalk via published WCF-based web services I often promote the idea that messages received by this web service should be validated before the sender of the message receives an acknowledgement that message was…(read more)
by community-syndication | Feb 15, 2011 | BizTalk Community Blogs via Syndication
Some of the beauty of using PowerShell is the ability to rapidly do things that would take a long time to do in .NET code. But you can do this without opening Visual Studio. I have found many uses for PowerShell in working with BizTalk. One area it comes in handy is working with BizTalk […]
by community-syndication | Feb 14, 2011 | BizTalk Community Blogs via Syndication
Another year, another Business Integration Roadshow. This year I’ll be unable to present, as I’ll be attending Microsoft’s MVP Summit in Redmond, but my two colleagues Tiago Oliveira and Ra%u00fal Ribeiro will present a session on the integration of BizTalk Server 2010 together with Windows Azure – “BizTalk + Azure – Better Together”. You can expect a few surprises and a eye-opener demo. 🙂
More information and registration for the event can be found here.
by community-syndication | Feb 14, 2011 | BizTalk Community Blogs via Syndication
The BizTalk Server 2010 Feature Pack is an add-on to BizTalk Server 2010 that allows BizTalk functionality to be invoked from Windows Azure’s Service Bus. The feature pack specifically includes “BizTalk Server 2010 AppFabric Connect for Services”, the feature that allows you to do this.
You can read more about how it works on the BizTalk Server Team Blog. Great feature!
by community-syndication | Feb 14, 2011 | BizTalk Community Blogs via Syndication
Tomorrow I will be giving a master class around BizTalk and AppFabric at my company. It will be a Dutch presentation on BizTalk Server 2010, AppFabric Connect and Windows Azure/Server AppFabric. With AppFabric connect one can extend reach of BizTalk orchestrations and LoB applications to the cloud. Most of information I will be sharing is similar to what can be found in:
- TechEd Session BizTalk What’s it?, What’s New..? and What’s next..?;
- BizTalk Server 2010 Training kit;
- BizTalk Server 2010 AppFabric Connect For Services;
- Windows Server AppFabric Samples;
- AppFabric Connect;
- BizTalk AppFabric Connect: An Introduction;
- Working with AppFabric Connect;
- Exposing LOB Services on the Cloud Using AppFabric Connect for Services;
- Exposing BizTalk Applications on the Cloud using AppFabric Connect for Services.
Session is open for all professionals inside and outside our company, partners and customers. With AppFabric integration will get a new meaning as capabilities with Microsoft technology and products grow on-premises and in the cloud.
Technorati: biztalk server 2010 appfabric
by community-syndication | Feb 13, 2011 | BizTalk Community Blogs via Syndication
After a couple of requests, I’ve created a separate git repository on github for my Molokai color scheme for Vim. Enjoy!
by community-syndication | Feb 10, 2011 | BizTalk Community Blogs via Syndication
Since BizTalk 2004 there has been an issue with the Backup BizTalk Server SQL Agent job (this is the only supported way to backup the BizTalk Server Databases), the issue is that the job never deletes the backup files it creates. There is a step in the job that clears the backup history table in the database but never delete the backup files from the disk.
In BizTalk 2004 I create a new stored procedure sp_DeleteBackupHistoryAndFiles to be used instead of the Microsoft supplied sp_DeleteBackupHistory, this stored procedure will delete the backup files create by the job when they exceed the value specified in the DaysToKeep parameter of the Clear Backup History step. With the release of BizTalk 2010 there have been changes to the sp_DeleteBackupHistory stored procedures, they are adding a parameter to the stored procedure to use local time and changed to the query to prevent the deletion of the history from the last full backup set forward.
I have made the same update to my sp_DeleteBackupHistoryAndFiles stored procedure, this stored procedure can be downloaded from the download page on BizTalkBill.com and it is called BizTalk 2010 Stored Procedure to delete backups
Warning: sp_DeleteBackupHistoryAndFiles requires xp_cmdshell to be enabled on the SQL Server
Installation Instructions:
- Download and execute the script in your BizTalk Management Database (BizTalkMgmtDb)
- Open the Backup BizTalk Server SQL Agent Job
- Open the Clear Backup History Step
- Change the stored procedure being execute from sp_DeleteBackupHistory to sp_DeleteBackupHistoryAndFiles
- Add @UseLocalTime = 1 (if you are using local time in the MarkAndBackupLog step
- Click OK until the job is saved.
If instruction to enable xp_cmdshell are needed please see SQL Books Online – http://msdn.microsoft.com/en-us/library/ms190693(v=SQL.100).aspx
Please Note: I am in the final process of testing a SSIS Package to delete the backup files that does not require xp_cmdshell