Write Ahead Blog

rushi desai | developer | zune service

March, 2005

  • Write Ahead Blog

    WAITFOR (RECEIVE ...) does not poll!

    • 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

    • 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

    • 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

    • 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...
  • Write Ahead Blog

    Desktop uprade wishlist

    • 0 Comments
    My PC may be only one and half years old, but I've already started feeling the urge to upgrade it. After starting most common applications, I find myself hitting that 384MB physical memory limit. And when I hear my hard disk clatter as I open files, I...
  • Write Ahead Blog

    Cω programming language and database/XML applications

    • 0 Comments
    I found this article on MSDN about a new programming language called Cω (C-omega) that was quite interesting. It is a language created by Microsoft Research that looks a lot like C# but has new constructs that help programmers to access and process XML...
  • Write Ahead Blog

    Routing Service Broker conversations (Part 2)

    • 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

    Broker in SQL Server Express

    • 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 1)

    • 0 Comments
    To allow conversations across SQL Server instances, Service Broker provides a binary adjacent transport protocol. Brokers can communicate directly from initiating service to target service or use multiple intermediate forwarding brokers. In order to identify...
Page 1 of 1 (9 items)