Blog - About

About Have Data Will Travel

This blog primarily talks about the role of data in connected systems architectures.

  • Have Data Will Travel

    Where does Service Broker Fit?

    • 6 Comments
    One of the most frequently asked questions I get when talking about Service Broker is how does it fit with the other messaging products that Microsoft has. Specifically, I hear a lot about MSMQ, WCF (Indigo) and BizTalk . In this post, I will try to clarify...
  • Have Data Will Travel

    Business Logic in the Database?

    • 4 Comments
    Business Logic in the Database? One of the basic tenants of three-tiered architectures was that business logic was a middle-tier thing and should never be in the database. Stored procedures were a hold-over from the bad-old days of client server...
  • Have Data Will Travel

    MDM Master Data Management Hub Architecture

    • 2 Comments
    MDM Master Data Management Hub Architecture I’m doing a presentation on Master Data Management (MDM) in February so I’m going to do another series of architecture articles like I did for Service Broker but this time for MDM. I will start with the...
  • Have Data Will Travel

    Architecting Service Broker Applications

    • 5 Comments
    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,...
  • Have Data Will Travel

    Backing Up Express

    • 10 Comments
    Backing Up Express One of the most common complaints I hear about SQL Express is that because it doesn’t include SQL Agent, there is no way to schedule backups. I won’t go into the reasons for why Agent is not in Express but I thought it would be...
  • Have Data Will Travel

    Message Priority

    • 3 Comments
    Message Priority (Who’s on First?) Another question I have been asked more times than I can remember is “why doesn’t Service Broker have message priority?” On one hand the answer is “of course Service Broker has message priority”. Every message...
  • Have Data Will Travel

    Compensating Transactions

    • 4 Comments
    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...
  • Have Data Will Travel

    Master Data is not Metadata

    • 1 Comments
    Master Data is not Metadata I regularly get emails from people asking about the Microsoft Metadata story. While I assume that’s mainly confusion over the MDM acronym which could reasonably be interpreted as Metadata Management as well as Master...
  • Have Data Will Travel

    MDM Master Data Management Hub Architecture – Population and Synchronization

    • 1 Comments
    MDM Master Data Management Hub Architecture – Population and Synchronization If you have been following this series you should now have a good understanding of the architectural issues around deciding what your MDM hub database looks like and what...
  • Have Data Will Travel

    Recycling Dialogs

    • 11 Comments
    Recycling Dialogs In virtually all the Service Broker articles, books, presentations, and blog samples I have done over the years, one message is sent from the initiator to the target, a response is sent from the target to the initiator and END...
  • Have Data Will Travel

    Whither IMDB?

    • 4 Comments
    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...
  • Have Data Will Travel

    Master Data Management, Microsoft, and Stratature

    • 2 Comments
    Master Data Management, Microsoft, and Stratature If you’re a regular reader, you are aware that I have been blogging about MDM for about a year now. I’m very excited by the news that Microsoft acquired Stratature last week for two reasons – I think...
  • Have Data Will Travel

    MDM and EAG and CDI Oh My! (Part 1)

    • 4 Comments
    MDM and EAG and CDI Oh My! (Part 1) One of the benefits often mentioned in SOA articles is data integration. When all your services communicate through messages with well-defined formats and schema, exchanging data between systems is easy right...
  • Have Data Will Travel

    MDM Master Data Management Hub Architecture – Versions and Hierarchies

    • 3 Comments
    MDM Master Data Management Hub Architecture – Versions and Hierarchies In my last post I talked about the options for implementing an MDM hub. In this post, I will drill into that a bit by discussing versions and hierarchies – two features that...
  • Have Data Will Travel

    MDM Master Data Management Hub Architecture – Maintenance and operation

    • 1 Comments
    MDM Master Data Management Hub Architecture – Maintenance and operation If you have been following this series, you have learned how to design an MDM hub database, how to load it with master data and how to keep the data synchronized with your operational...
  • Have Data Will Travel

    Windows WF on SQL Service Broker

    • 1 Comments
    Windows WF on SQL Service Broker From the time we first started working on the Service Broker programming models five or six years ago, it was obvious that most SSB programs end up looking a lot like a workflow. Messages come in and the application...
  • Have Data Will Travel

    Choosing MDM Hub styles

    • 1 Comments
    Choosing MDM Hub styles A couple weeks ago, someone asked me how to choose which MDM hub style would work best for an application. I thought I had covered this in one of my white papers but I couldn’t find a good reference to give him so I thought...
  • Have Data Will Travel

    Message Priority II

    • 4 Comments
    Message Priority Part Deux As I promised last week, here’s the code to demonstrate Service Broker priorities. First a disclaimer. I generally try to make my sample code complete enough so it can serve as the basis of a real app but in this...
  • Have Data Will Travel

    Architecting Service Broker applications (part 2)

    • 1 Comments
    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 http://blogs.msdn.com/rogerwolterblog/archive/2006/09/08/Roger.aspx ,...
  • Have Data Will Travel

    Analytical and Transactional MDM

    • 2 Comments
    Analytical and Transactional MDM I was talking to someone about Analytical and Transactional MDM recently and we realized that while there are quite a few conceptual differences between the two, there’s a significant amount of overlap in the implementation...
  • Have Data Will Travel

    Oracle Advanced Queuing

    • 1 Comments
    Oracle Advanced Queuing When I talk to people about all the advantages that Service Broker has because it is built into the database, I frequently get asked about Oracle Advanced Queuing (OAQ) which after all is built into Oracle . OAQ queues are...
  • Have Data Will Travel

    SQL Server Express & Everywhere

    • 5 Comments
    SQL Server Express & Everywhere I assume by now most SQL Server fans know that SQL Server Mobile Edition has been released on Windows and the name has been changed to SQL Server Everywhere Edition. The first thing I noticed about this is there...
  • Have Data Will Travel

    Paging in Service Oriented Architectures

    • 1 Comments
    Paging in Service Oriented Architectures We had an interesting Email thread a couple weeks ago about how you support pages of output to a UI in a Service Oriented Architecture. My initial thought is that you don’t. If you are truly building loosely...
  • Have Data Will Travel

    MDM and EAG and CDI Oh My! (Part 2)

    • 6 Comments
    MDM and EAG and CDI Oh My! (Part 2) I covered customer master data in the first part because that’s generally both the most critical and most difficult problem to solve but any data that is going to be aggregated by a service may have issues with...
  • Have Data Will Travel

    Architecting Service Broker applications (part 3)

    • 2 Comments
    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: http://blogs.msdn.com/rogerwolterblog/archive/2006...
Page 1 of 2 (47 items) 12