Sign in
Write Ahead Blog
rushi desai | developer | zune service
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
No tags have been created or used yet.
Archive
Archives
November 2007
(1)
September 2006
(2)
April 2006
(1)
December 2005
(3)
November 2005
(1)
September 2005
(3)
June 2005
(4)
May 2005
(4)
April 2005
(2)
March 2005
(9)
February 2005
(11)
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Write Ahead Blog
Shipping rowsets across databases using Service Broker
Posted
over 8 years ago
by
Rushi Desai
6
Comments
[Attachment: ShippingRowsets.zip ] While there are technologies such as log shipping, SQL Server Replication Service and database mirroring available for various scenarios that require maintaining a copy of the data in a secondary source, several customers...
Write Ahead Blog
SODA (Service-Oriented Data Architecture) at TechEd
Posted
over 8 years ago
by
Rushi Desai
4
Comments
Where do relational databases systems fit to provide reliability, scalability and resilience to loosely-coupled world of Service-Oriented Architecture (SOA)? Fueled by XML, CLR hosting, integration with Visual Studio 2005, native web-services, asynchronous...
Write Ahead Blog
Building a community debt tracker webapp
Posted
over 8 years ago
by
Rushi Desai
3
Comments
Having built webapps in Java and PHP, I have been curious about ASP.NET. So I decided to teach myself some basic ASP.NET programming by building a useful webapp. A common problem that I've faced going for dinners/movies/shopping with other single friends...
Write Ahead Blog
App Partitioning: Data Dependent Routing and Forwarding
Posted
over 8 years ago
by
Rushi Desai
3
Comments
One strategy to achieve scale-out is replicating data. Another is partitioning. Each has its own advantages and limitations; and you’d use one over the other depending on the nature of the data itself as well as the access pattern. While Service Broker...
Write Ahead Blog
[PDC 2005] DAT303 SQL Server 2005: Building Distributed, Asynchronous Database Applications with the Service Broker
Posted
over 8 years ago
by
Rushi Desai
2
Comments
You can now download the demos used in Gerald and Roger's PDC talk on the Service Broker from SSB CodeGallery . The demos include: Basics - Creating metadata, beginning a dialog, sending a message and receiving a message. CLR Services - Writing...
Write Ahead Blog
Running auctions on SQL Server 2005
Posted
over 8 years ago
by
Rushi Desai
2
Comments
[Attachment: CommodityExchange.zip ] We studied auctions in our e-commerce and AI classes at U of M . In one of our assignments we were asked to configure an agent that played the Trading Agent Competition ( TAC ) which involved a variety of auctions...
Write Ahead Blog
Activating stored procedures asynchronously
Posted
over 8 years ago
by
Rushi Desai
2
Comments
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...
Write Ahead Blog
Introduction
Posted
over 8 years ago
by
Rushi Desai
2
Comments
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...
Write Ahead Blog
What is Service Broker?
Posted
over 8 years ago
by
Rushi Desai
2
Comments
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...
Write Ahead Blog
Invalidating cached result sets using SQL Server Query Notification
Posted
over 8 years ago
by
Rushi Desai
1
Comments
Anyone who has written a web application has probably experienced the cost of doing a database round trip for fetching a result set everytime a web user loads a page. In fact, handling a page request may involve more than one queries (imagine 20 drop...
Write Ahead Blog
Broker in SQL Server Express
Posted
over 8 years ago
by
Rushi Desai
1
Comments
I have been asked more than once if SQL Server Express has the Service Broker feature and if there are any limitations on the use. SQL Server 2005 Express Edition is a version of SQL Server 2005 that is available for free (strategically being released...
Write Ahead Blog
Routing Service Broker conversations (Part 2)
Posted
over 8 years ago
by
Rushi Desai
1
Comments
In a previous post , I described the basic routing architecture of Service Broker. What I did not describe was a special facility that allows you to exploit external mechanisms for finding routes. For example, an enterprise may use Active Directory or...
Write Ahead Blog
Comparing Service Broker with other messaging technologies
Posted
over 8 years ago
by
Rushi Desai
1
Comments
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...
Write Ahead Blog
Using <font face="courier" color="navy">Microsoft.SqlServer.Broker</font> class library for writing .NET service programs
Posted
over 8 years ago
by
Rushi Desai
1
Comments
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...
Write Ahead Blog
[BrokerChallenge 0] SEND me a message
Posted
over 8 years ago
by
Rushi Desai
1
Comments
Over the past week I have been planning to launch the first open to public Service Broker. At the same time, my dev team was having a discussion regarding how we can do something cool and interesting to get the community involved in our product. So I...
Write Ahead Blog
Solution to BrokerChallenge 0
Posted
over 8 years ago
by
Rushi Desai
1
Comments
It has been a week since I posted BrokerChallenge 0 and I am quite happy to see several people successfully cracked it. Still others gave it a shot but were not completely successful. So I decided to post the solution to the challenge. You can get the...
Write Ahead Blog
Activating queue reader processes on demand (Part 2)
Posted
over 8 years ago
by
Rushi Desai
1
Comments
Following up on my article titled " Activating queue reader processes on demand ", we are launching the External Activator sample. This sample demonstrates how you can build scalable Service Broker applications as executable processes that may be started...
Write Ahead Blog
Service Broker official documentation on SQL Server 2005 Books Online
Posted
over 8 years ago
by
Rushi Desai
1
Comments
The official documentation for SQL Server 2005 (called 'Books Online') is now available on MSDN. You can read the Service Broker section by clicking on the following link: http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
Write Ahead Blog
Replacing an MSMQ queue with a SQL Server 2005 queue
Posted
over 8 years ago
by
Rushi Desai
1
Comments
Today, we did a short presentation on Service Broker for a customer who is interested in using the Service Broker technology. Their current application uses a large backend SQL Server database that is accessed from several mid-tier servers. In one of...
Write Ahead Blog
App Paritioning: Data Dependent Routing using Redirection
Posted
over 8 years ago
by
Rushi Desai
1
Comments
Following up on my previous post regarding how to talk to partitioned services with data dependent routing, here is another mechanism -- redirection. One of the main drawbacks of having the routing service forward messages to the final target service...
Write Ahead Blog
Reliably making a web-request from the database
Posted
over 7 years ago
by
Rushi Desai
1
Comments
One of the prime use cases of the CLR integration in SQL Server 2005 is to make outbound HTTP requests to web applications or web services. But how do you do that reliably given the large number of failures that need to be handled ranging from network...
Write Ahead Blog
Where did all the images go?
Posted
over 7 years ago
by
Rushi Desai
1
Comments
If you are wondering if the disappearance of images from my blog had anything to do with moving it back to blogs.msdn.com, you are on the right track. The reason I moved the blog was that my computer which was hosting the blog had a RAID-0 failure causing...
Write Ahead Blog
External Activator HOWTO
Posted
over 7 years ago
by
Rushi Desai
1
Comments
After receiving several requests, I have put together simple documentation on how to use the External Activator sample here .
Write Ahead Blog
hello again
Posted
over 6 years ago
by
Rushi Desai
1
Comments
After missing for over a year I decided to start blogging again. Much has changed. I no longer work in the SQL Server Engine team on Service Broker. I moved to the Zune team to work on web-services that power the Zune marketplace and have been quite busy...
Write Ahead Blog
Remus joins the blogosphere
Posted
over 8 years ago
by
Rushi Desai
0
Comments
My teammate Remus Rusanu spawned his blog today with a great article on how to write a simple publish-subscribe service in SQL Server 2005 using Service Broker. While SQL Server 2005 does not natively support a pub-sub architecture and the only type of...
Page 1 of 2 (41 items)
1
2