SQL Service Broker: The Impatient Way!

For those of you who are interested in creating your first SQL Server 2005 Service Broker conversation but are impatient as I am, just grab the code below and give it a try: — Enable service brokeralter database [YOUR_DB_NAME] set enable_broker — Create a message type. You can also specify —  An XML schema to…

0

WCF Tools

WCF provides a number of tools that make it easier to create, deploy, and administer WCF applications. Tool Name Description COM+ Service Model Configuration Tool (ComSvcConfig.exe) This is a utility used to configure service model integration for COM+ applications. Using this tool you can expose an interface within your COM+ component as a WCF web…

0

How to use gacutil in Vista

Well as you probably know by now Vista’s clever UAC ensures that gacutil is not run with Administrator privileges and usually for installing and uninstalling assemblies into the gac you’ll need admin rights. A simple solution is to right-click on a Command Prompt icon and select Run as Administrator. You can now use gacutil.exe to…

0

How to create a FOR loop in BizTalk mapper

In order to achieve this, we will be using the Iteration functoid.  The Iteration functoid outputs the index of the current record in a looping structure. The XSLT generated by the BizTalk mapper, processes elements with possible multiple instances using a loop. In other words, an order book with unbounded number of orders would usually…

0

BizTalk’s Cumulative Functoids and their Scope

Biztalk’s powerful mapper tool, allows the reduction of multiple values into a single value. For instance it allows the user to sum up the values of all orders. However what if we are only interested in summing up the value of all the orders in the scope of their parent order book? Well in that…

1

Windows Workflow Foundation (Basics): How to handle external events and to trigger state transitions using a HandleExternalEvent activity

  MSDN’s description for a HandleExternalEvent reads as “Defines a workflow communication activity that is used to handle an event that is raised by a local service”. In this blog I will try to expand on that definition. Imagine a simple state machine representing a moving (state = Moving) or non-moving (state = Stopped) vehicle. For simplicity, let’s assume that the…

9