ASP.NET News from Blogger: Write Ahead Blog   Get the feed of: Write Ahead Blog

Total News: 21

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 back to blogs.msdn.com, you are on the right track. The reason I moved the blog was that my computer ...

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 requests to web applications or web services. But how do you do that reliably given the large number of f...

App Paritioning: Data Dependent Routing using Redirection

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 se...

App Partitioning: Data Dependent Routing and Forwarding

One strategy to achieve scale-out is replicating data. Another is partitioning. Each has its own advantages and limitations; and youd use one over the other depending on the nature of the data itself ...

Remus joins the blogosphere

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...

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 can read the Service Broker section by clicking on the following link:     http://ms...

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 have to first create your message types and contracts to be able to begin a dialog and send message...

[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 CodeGallery. The demos include: Basics - Creating metadata, beginning a dialog, sending a message and...

Activating queue reader processes on demand (Part 2)

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 ap...

Solution to BrokerChallenge 0

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 ...

[BrokerChallenge 0] SEND me a message

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 ...

SODA (Service-Oriented Data Architecture) at TechEd

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 wit...

Shipping rowsets across databases using Service Broker

[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 co...

Managing scheduled async SQL Server tasks

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. ...

Running auctions on SQL Server 2005

[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 Agen...

First book entirely dedicated to Service Broker

The Rational Guide To SQL Server 2005 Service Broker (Beta Preview)by Roger WolterISBN: 1932577203 Roger, our group program manager for Service Broker is writing a book on developing and depl...

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 myself some basic ASP.NET programming by building a useful webapp. A common problem that I've faced going...

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 Service Broker technology. Their current application uses a large backend SQL Server d...

Admin interface for Service Broker

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 r...

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 trip for fetching a result set everytime a web user loads a page. In fact, handling a page request ...

WAITFOR (RECEIVE ...) does not poll!

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 unti...

View Other bloggers