Applied Architecture Patterns on the Microsoft Platform Available In India for 400 Rs

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

Microsoft Business Integration RoadShow 2011 (Lisboa, 28/Fev)

Microsoft Business Integration RoadShow 2011 (Lisboa, 28/Fev)

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.

Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

BizTalk Server 2010 Feature Pack

BizTalk Server 2010 Feature Pack

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!

Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

Masterclass BizTalk and AppFabric

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

Update to Stored Procedure to delete Backup BizTalk Server SQL Agent backup files

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