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

A very basic and completely insufficient introduction to data integration with SQL Server


There are lots of cool features in SQL Server 2008. Complete books and hundreds of blogs, articles, TechNet, and MSDN pages have been written on each of these subjects. These below sections on SQL Server's suite of tools are focused on data integration problems, with occasional forays into the author's pet peeves around data security. We will, therefore, limit the discussion to key integration technologies and my apologies in advance for merely scratching the surface of these rich and robust environments.

SSIS

SSIS has no core technologies as such; its core is SQL Server itself. One should think of SSIS as a collection of objects that create a powerful visual environment for performing a multitude of tasks associated with master data management, database maintenance, data integration, and ETL projects.

You create SSIS projects in Business Intelligence Development Studio in Microsoft Visual Studio. SSIS...