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
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
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)
MSDN Blogs
>
Write Ahead Blog
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Write Ahead Blog
hello again
Posted
over 5 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
External Activator HOWTO
Posted
over 6 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
Where did all the images go?
Posted
over 6 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
Reliably making a web-request from the database
Posted
over 6 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
App Paritioning: Data Dependent Routing using Redirection
Posted
over 7 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
App Partitioning: Data Dependent Routing and Forwarding
Posted
over 7 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
Remus joins the blogosphere
Posted
over 7 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...
Write Ahead Blog
Service Broker official documentation on SQL Server 2005 Books Online
Posted
over 7 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
[PDC 2005] DAT303 SQL Server 2005: Building Distributed, Asynchronous Database Applications with the Service Broker
Posted
over 7 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
Exporting and importing service listings into a database
Posted
over 7 years ago
by
Rushi Desai
0
Comments
You implemented a Service Broker service and now want others to be able to talk to it. But they will have to first create your message types and contracts to be able to begin a dialog and send messages to your target service. If their service does not...
Write Ahead Blog
Activating queue reader processes on demand (Part 2)
Posted
over 7 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
Solution to BrokerChallenge 0
Posted
over 7 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
[BrokerChallenge 0] SEND me a message
Posted
over 7 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
SODA (Service-Oriented Data Architecture) at TechEd
Posted
over 7 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
Shipping rowsets across databases using Service Broker
Posted
over 7 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
Managing scheduled async SQL Server tasks
Posted
over 7 years ago
by
Rushi Desai
0
Comments
DBAs often struggle with setting up automated tasks for managing databases such as taking backups, maintaining warehouses, re-building indexes and generating scheduled reports just to mention a few. While Service Broker is seen mostly as a framework for...
Write Ahead Blog
Running auctions on SQL Server 2005
Posted
over 7 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
First book entirely dedicated to Service Broker
Posted
over 7 years ago
by
Rushi Desai
0
Comments
The Rational Guide To SQL Server 2005 Service Broker (Beta Preview) by Roger Wolter ISBN: 1932577203 Roger, our group program manager for Service Broker is writing a book on developing and deploying Service Broker applications. The beta preview version...
Write Ahead Blog
Building a community debt tracker webapp
Posted
over 7 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
Replacing an MSMQ queue with a SQL Server 2005 queue
Posted
over 7 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
Admin interface for Service Broker
Posted
over 7 years ago
by
Rushi Desai
0
Comments
Niels Berglund has posted a much wanted tool for Service Broker. SSB Admin is a GUI application for managing and creating Service Broker objects in SQL Server 2005. For more information see his recent blog post .
Write Ahead Blog
WAITFOR (RECEIVE ...) does not poll!
Posted
over 7 years ago
by
Rushi Desai
0
Comments
A lot of people have been concerned about using the WAITFOR (RECEIVE ...) statement for receiving Service Broker messages from a queue. Several believe that this would poll the queue continuously until messages become available in the queue either by...
Write Ahead Blog
Invalidating cached result sets using SQL Server Query Notification
Posted
over 7 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
WSE 2.0 Transport for Service Broker
Posted
over 7 years ago
by
Rushi Desai
0
Comments
Having seen implementations of MSMQ, SMTP and UDP transport providers for WSE, I was sure someone would come up with one for Service Broker as well. I played around with this for a bit but only got to implement the sender side. Mike Taulty recently released...
Write Ahead Blog
Subscribing a broker service to SQL events
Posted
over 7 years ago
by
Rushi Desai
0
Comments
One of the cool uses of SQL Service Broker is event notification. SQL Server 2005 introduces a mechanism for notifying events such as execution of a DDL statement or occurence of a SQL Trace event to a Service Broker service. Notifications are delivered...
Page 1 of 2 (41 items)
1
2