Service Oriented Database Architecture Paper
Oh, geez. I missed somehow that the paper had gone live. But thanks to Kim Tripp, I now know that you can read my Service Oriented Database Architecture (SODA) paper on TechNet. This is something I did for Microsoft late last year. The SQL Server group wanted a rewrite of Dave Campbell’s seminal Service Oriented Database Architecture: App Server-Lite? and I was lucky enough to get the nod. Dave’s original was an academic paper that covered the high-level concepts, written for an Association for Computing Machinery conference in 2005, and the team wanted something specifically focused on SQL Server 2005.
Doing the rewrite required that I look at SQL Server 2005 in a whole new way, as a node in a Service Oriented Architecture (SOA). It required that I get my head out of a narrow view of SQL Server as a simple data store and how all the new features make it a full-featured SOA node. I was amazed at how this explained so many of the design desisions that the SQL Server team made for the new version. It all made sense!
The scariest part of doing this paper was having Dave Campbell as a technical editor. I connected briefly with him at SQL PASS last year in Dallas. He was pretty brutal in his feedback—but politely so—which immensely helped my understanding of this use of SQL Server.