The What, Why, and How of Master Data Management

My friend Kirk Haselden and I wrote a white paper about Master Data Management.  It is available here:  The purpose of this paper was to explain what MDM is, why MDM is important, and some of the architectural issues and options involved in implementing an MDM system.  This is intended to be this first…


Architecting Service Broker Applications White Paper

For those of you who would like to see the SSB Architecture posts all in one place, I converted them into a white paper on MSDN here:  There’s not much new material beyond what was in the blog posts but it’s all in one place.


Architecting Service Broker applications (part 3)

Architecting Service Broker applications (part 3)   This is the final installment (I promise) of my Architecting SQL Service Broker (SSB) applications series.  If you haven’t read the first two parts: , I would recommend reading them before tackling this one.  In this post I will cover some of the infrastructure aspects of…


Architecting Service Broker applications (part 2)

Architecting Service Broker applications (part 2)   This is the second in a series on architecting SQL Server 2005 Service Broker (SSB) applications.  If you haven’t read part 1 , I would advise reading it first.  The first article covered the Service Broker “materials” available for building Service Broker applications and this article covers…


Architecting Service Broker Applications

Architecting Service Broker Applications   I signed up to do a presentation on Architecting Service Broker Applications so I thought I would write up my thinking here to see if I got any useful feedback.  Pretty much all the presentations, papers, and books I have seen or written talk about how to build a Service…


Roving Services

Roving Services   When I set out to post this, I realized I haven’t post to my blog for a couple months.  My only excuse is I took more vacation this summer than I ever have before.   I spent a lot of time in airports and on airplanes so I thought I would get a…


Scaleout Training

Scaleout Training   If you read my scaleout article: you know Service Oriented Data Architecture is one of the most interesting scaleout technologies for SQL Server 2005.  If you are interested in how to use SODA and the new features in SQL Server 2005 to scaleout your SQL Server applications, my friend Bob Beauchemin is offering SODA…


New edition of my Book

New edition of my Book   I get asked periodically when the RTM version of my Service Broker book will be available.  It was released just before TechEd so it should be easy to find.   The Rational Guide to SQL Server 2005 Service Broker


Whither IMDB?

 Whither IMDB?   Last week a customer asked me what happened to the in-memory database (IMDB) that was originally suppose to be part of Windows 2000.  While I had almost no involvement with IMDB, one of the people who was involved worked for me at the time so I was around when the decision to…


Compensating Transactions

Compensating Transactions   At the Federal Architect Forum a couple weeks ago I was asked “when is SQL Server going to have compensating transactions?”  Since this comes up pretty regularly, I thought I would write a little background on what this means.   First, let’s understand what a compensating transaction is and why we you…