Write Ahead Blog

rushi desai | developer | zune service

hello again

After missing for over a year I decided to start blogging again. Much has changed. I no longer work...

Date: 11/16/2007

External Activator HOWTO

After receiving several requests, I have put together simple documentation on how to use the...

Date: 09/25/2006

Where did all the images go?

If you are wondering if the disappearance of images from my blog had anything to do with moving it...

Date: 09/25/2006

Reliably making a web-request from the database

One of the prime use cases of the CLR integration in SQL Server 2005 is to make outbound HTTP...

Date: 04/19/2006

App Paritioning: Data Dependent Routing using Redirection

Following up on my previous post regarding how to talk to partitioned services with data dependent...

Date: 12/28/2005

App Partitioning: Data Dependent Routing and Forwarding

One strategy to achieve scale-out is replicating data. Another is partitioning. Each has its own...

Date: 12/22/2005

Remus joins the blogosphere

My teammate Remus Rusanu spawned his blog today with a great article on how to write a simple...

Date: 12/13/2005

Service Broker official documentation on SQL Server 2005 Books Online

The official documentation for SQL Server 2005 (called 'Books Online') is now available on MSDN. You...

Date: 11/05/2005

[PDC 2005] DAT303 SQL Server 2005: Building Distributed, Asynchronous Database Applications with the Service Broker

You can now download the demos used in Gerald and Roger's PDC talk on the Service Broker from SSB...

Date: 09/14/2005

Exporting and importing service listings into a database

You implemented a Service Broker service and now want others to be able to talk to it. But they will...

Date: 09/14/2005

Activating queue reader processes on demand (Part 2)

Following up on my article titled "Activating queue reader processes on demand", we are launching...

Date: 09/13/2005

Solution to BrokerChallenge 0

It has been a week since I posted BrokerChallenge 0 and I am quite happy to see several people...

Date: 06/24/2005

SODA (Service-Oriented Data Architecture) at TechEd

Where do relational databases systems fit to provide reliability, scalability and resilience to...

Date: 06/07/2005

Shipping rowsets across databases using Service Broker

[Attachment: ShippingRowsets.zip] While there are technologies such as log shipping, SQL Server...

Date: 06/04/2005

Managing scheduled async SQL Server tasks

DBAs often struggle with setting up automated tasks for managing databases such as taking backups,...

Date: 05/20/2005

Running auctions on SQL Server 2005

[Attachment: CommodityExchange.zip] We studied auctions in our e-commerce and AI classes at U of M....

Date: 05/19/2005

First book entirely dedicated to Service Broker

The Rational Guide To SQL Server 2005 Service Broker (Beta Preview)by Roger WolterISBN: 1932577203...

Date: 05/12/2005

Building a community debt tracker webapp

Having built webapps in Java and PHP, I have been curious about ASP.NET. So I decided to teach...

Date: 05/03/2005

Replacing an MSMQ queue with a SQL Server 2005 queue

Today, we did a short presentation on Service Broker for a customer who is interested in using the...

Date: 04/28/2005

Admin interface for Service Broker

Niels Berglund has posted a much wanted tool for Service Broker. SSB Admin is a GUI application for...

Date: 04/26/2005

WAITFOR (RECEIVE ...) does not poll!

A lot of people have been concerned about using the WAITFOR (RECEIVE ...) statement for receiving...

Date: 03/19/2005

Invalidating cached result sets using SQL Server Query Notification

Anyone who has written a web application has probably experienced the cost of doing a database round...

Date: 03/19/2005

WSE 2.0 Transport for Service Broker

Having seen implementations of MSMQ, SMTP and UDP transport providers for WSE, I was sure someone...

Date: 03/18/2005

Subscribing a broker service to SQL events

One of the cool uses of SQL Service Broker is event notification. SQL Server 2005 introduces a...

Date: 03/15/2005

Desktop uprade wishlist

My PC may be only one and half years old, but I've already started feeling the urge to upgrade it....

Date: 03/07/2005

Cω programming language and database/XML applications

I found this article on MSDN about a new programming language called Cω (C-omega) that was quite...

Date: 03/04/2005

Routing Service Broker conversations (Part 2)

In a previous post, I described the basic routing architecture of Service Broker. What I did not...

Date: 03/04/2005

Broker in SQL Server Express

I have been asked more than once if SQL Server Express has the Service Broker feature and if there...

Date: 03/03/2005

Routing Service Broker conversations (Part 1)

To allow conversations across SQL Server instances, Service Broker provides a binary adjacent...

Date: 03/03/2005

Stumbling into cross-threading issues with winforms

Having very little prior UI programming experience, I ventured into writing an instant messenger...

Date: 02/25/2005

Download and try the InfoPathBroker sample

Following up on my previous article, I decided to provide a sample that people could try for...

Date: 02/22/2005

Activating queue reader processes on demand

In a previous post, I talked about internal activation. But it may not always be feasible to write...

Date: 02/19/2005

Integrating InfoPath with SQL Server 2005

I discovered InfoPath only a few months ago and started wondering how it could be used in enterprise...

Date: 02/18/2005

SQLOS

One of the privileges of being in the SQL Server Engine team is that we have our own operating...

Date: 02/12/2005

Using Microsoft.SqlServer.Broker class library for writing .NET service programs

Service Broker programs may be written as stand-alone applications that establish a connection with...

Date: 02/12/2005

Comparing Service Broker with other messaging technologies

An often asked question about SQL Service Broker is how it compares with other products offered by...

Date: 02/11/2005

Activating stored procedures asynchronously

I was tempted to post a HelloWorld sample for Service Broker, but since Roger Wolter's article...

Date: 02/09/2005

Learning Windows Internals

Coming straight out of the UNIX-dominated academic world, I realized that I have negligible...

Date: 02/06/2005

What is Service Broker?

A number of large database applications require asynchronous and distributed execution. Most...

Date: 02/06/2005