Book Image

Applied Architecture Patterns on the Microsoft Platform

Book Image

Applied Architecture Patterns on the Microsoft Platform

Overview of this book

Every day, architects and developers are asked to solve specific business problems in the most efficient way possible using a broad range of technologies. Packed with real-world examples of how to use the latest Microsoft technologies, this book tackles over a dozen specific use case patterns and provides an applied implementation with supporting code downloads for every chapter. In this book, we guide you through thirteen architectural patterns and provide detailed code samples for the following technologies: Windows Server AppFabric, Windows Azure Platform AppFabric, SQL Server (including Integration Services, Service Broker, and StreamInsight), BizTalk Server, Windows Communication Foundation (WCF), and Windows Workflow Foundation (WF). This book brings together – and simplifies – the information and methodology you need to make the right architectural decisions and use a broad range of the Microsoft platform to meet your requirements. Throughout the book, we will follow a consistent architectural decision framework which considers key business, organizational, and technology factors. The book is broken up into four sections. First, we define the techniques and methodologies used to make architectural decisions throughout the book. In Part I, we provide a set of primers designed to get you up to speed with each of the technologies demonstrated in the book. Part II looks at messaging patterns and includes use cases which highlight content-based routing, workflow, publish/subscribe, and distributed messaging. Part III digs into data processing patterns and looks at bulk data processing, complex events, multi-master synchronization, and more. Finally, Part IV covers performance-related patterns including low latency, failover to the cloud, and reference data caching.
Table of Contents (26 chapters)
Applied Architecture Patterns on the Microsoft Platform
Credits
Foreword
About the Authors
About the Reviewer
Preface

Chapter 5. SQL Server and Data Integration Tools Primer

Way back in the Permian epoch of database technologies, circa 2000 CE to 2005 CE, data integration in the Microsoft stack was accomplished through DTS and MSMQ. Like in the real Permian epoch, huge bugs roamed the landscape, ready to devour the lives of the poor database professional stuck in the La Brea tar pits of system integration support and master data management.

Those of us who look back on those days and shudder were truly grateful for the introduction of SQL Server Integration Services (SSIS) and SQL Server Service Broker (SSSB) with SQL Server 2005. SQL Server 2008 now supports multiple tools for data integration and master data management, including the following functionalities:

  • SSIS new functionality

  • SSSB

  • Master Data Services

  • The Sync Framework, for databases that are only occasionally connected with your networks

With SSIS, SSSB, Master Data Services, and the Sync Framework, database professionals can actually see their children...