Aschenbrenner Pro SQL Server 2008 Service Broker

1. ed
ISBN: 978-1-4302-0865-5
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 600 Seiten

Service Broker is a key Microsoft product in support of message-based processing between applications. Pro SQL Server 2008 Service Broker helps you to take full advantage of this key Microsoft technology, beginning from the fundamentals, moving through installation and application development, and ultimately showing you how to develop highly available and scalable applications based upon the service-oriented architecture that is quickly gaining ground as the way forward in application development. Comprehensive approach to developing with Service Broker Strong focus on best practices and real-world scenarios Covers the key aspects of distributed application design

Klaus Aschenbrenner is a software architect for ANECON in Vienna, Austria. He has worked with .NET since its release in 2000 and is an internationally recognized .NET expert and a two-time 'Most Valuable Professional' for Visual C#. He travels around the world helping clients design and develop highly-scalable solutions using SQL Server 2005 and Service Broker. Klaus is the founder of .NET User Group Styria and also the country lead for SQLPASS Austria.

Autoren/Hrsg.

Aschenbrenner, Klaus

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Author;13
4;About the Technical Reviewer;14
5;Acknowledgments;15
6;Introduction;17
6.1;Who This Book Is For;17
6.2;How This Book Is Structured;17
6.3;Prerequisites;19
6.4;Downloading the Code;19
6.5;Contacting the Author;19
7;The Service Broker Programming Model;20
7.1;Fundamentals of Message- Based Processing;21
7.1.1;Message Concepts;22
7.1.2;Why Messaging?;24
7.1.3;Messaging Problems;27
7.1.4;Messaging Architectures;30
7.1.5;Available Messaging Technologies;32
7.1.6;Summary;34
7.2;Introducing Service Broker;35
7.2.1;Conversations;35
7.2.2;Anatomy of a Service;40
7.2.3;Security;44
7.2.4;Message Processing;46
7.2.5;Performance;47
7.2.6;Benefits;49
7.2.7;Summary;49
7.3;Service Broker in Action;50
7.3.1;Defining Service Broker Applications;50
7.3.2;Message Types;51
7.3.3;Contracts;54
7.3.4;Queue;58
7.3.5;Service;60
7.3.6;Sending Messages;64
7.3.7;Retrieving and Processing Messages;70
7.3.8;Retrieving Messages;71
7.3.9;Processing Messages;74
7.3.10;Error Handling;79
7.3.11;Summary;89
7.4;Service Broker Activation;90
7.4.1;Activation Basics;90
7.4.2;Internal Activation;94
7.4.3;External Activation;120
7.4.4;Parallel Activation;136
7.4.5;Troubleshooting Activation;141
7.4.6;Summary;143
7.5;Service Broker with Managed Code;144
7.5.1;The Managed Assembly;145
7.5.2;Architecture and Design of the Managed Assembly;148
7.5.3;Building a Managed Service Broker Client;154
7.5.4;Building a Managed Service Program;160
7.5.5;A Practical Example;168
7.5.6;Summary;178
7.6;Locking and Transaction Management;179
7.6.1;Conversation Groups and Locks;179
7.6.2;Transaction Management;238
7.6.3;Summary;254
7.7;Distributed Service Broker Applications;255
7.7.1;Communication;255
7.7.2;Routing;258
7.7.3;Distributed Applications;262
7.7.4;Summary;283
8;Advanced Service Broker Programming;285
8.1;Advanced Distributed Service Broker Programming;286
8.1.1;Transport Security;287
8.1.2;Dialog Security;290
8.1.3;Encryption;302
8.1.4;Transport Protocol;305
8.1.5;Replacing Certificates;309
8.1.6;Service Listing Manager;311
8.1.7;Summary;319
8.2;Service-Oriented Database Architecture;320
8.2.1;Service-Oriented Database Architecture;320
8.2.2;Data in SODA;323
8.2.3;SODA Features in SQL Server 2008;326
8.2.4;Summary;365
8.3;Real-World Application Scenarios;366
8.3.1;Reliable Web Service Requests;367
8.3.2;Asynchronous Triggers;391
8.3.3;Workflow-Driven Service Broker Solutions;401
8.3.4;Batch Frameworks;423
8.3.5;Publish-Subscribe Frameworks;435
8.3.6;Workload Throttling Through Service Broker;445
8.3.7;Priority-Based Message Processing;460
8.3.8;Summary;474
8.4;High Availability and Scalability;475
8.4.1;Database Mirroring;476
8.4.2;Load Balancing;484
8.4.3;Message Forwarding;488
8.4.4;Configuration Notice Service;497
8.4.5;Data-Dependent Routing;504
8.4.6;Summary;525
8.5;Administration;526
8.5.1;SQL Server Management Studio;526
8.5.2;System Monitor;538
8.5.3;SQL Server Management Objects;543
8.5.4;Troubleshooting;547
8.5.5;Summary;562
9;Index;563