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