Write Ahead Blog

Having very little prior UI programming experience, I ventured into writing an instant messenger application (using SQL Service Broker of course). After doodling around with VC# and generously lock ing shared data structures, I thought I had got it right...

Following up on my previous article , I decided to provide a sample that people could try for building InfoPath interfaces to SQL Service Broker applications. The sample is a simple expense report form being submitted to backend HR broker service. You...

In a previous post, I talked about internal activation . But it may not always be feasible to write Service Broker programs as stored procedures. For example, the service program may take a long time to process a message or might require to make a call...

I discovered InfoPath only a few months ago and started wondering how it could be used in enterprise offices. InfoPath does a great job of building forms for publishing XML data quickly. It not only makes the task of building CRUD ( create/retrieve/update...

One of the privileges of being in the SQL Server Engine team is that we have our own operating system abstraction layer that provides virtual memory management, scheduling, synchronization, resource monitoring, exception handling and several other things...

Service Broker programs may be written as stand-alone applications that establish a connection with SQL Server or as stored procs that are activated internally . You can leverage the .NET platform in both scenarios since SQL Server 2005 integrates CLR...

An often asked question about SQL Service Broker is how it compares with other products offered by Microsoft such as MSMQ, BizTalk server, WSE and its successor Indigo. So I thought I’ll take a shot at answering this politically provocative question...

I was tempted to post a HelloWorld sample for Service Broker, but since Roger Wolter's article already provides that, I decided to avoid the redundancy. Instead I shall describe how to setup async execution using Service Broker's activation mechanism...

Coming straight out of the UNIX-dominated academic world, I realized that I have negligible knowledge of the Windows system architecture and kernel. Systems courses taught in most schools only use the UNIX-platform. So I have no idea what the windows...

A number of large database applications require asynchronous and distributed execution. Most loosely-coupled distributed systems provide scale out and resilience by queuing operations. Queues are used extensively in applications such as order entry systems...

I finally figured out how to get one of these .Text blogs setup on the http://blogs.msdn.com website. It was tricky to tweak the CSS in order to make it look and feel like my homepage . But finally the "Write Ahead Blog" is alive. I joined Microsoft just...