Pro SQL Server 2008 Service Broker (eBook)

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.

Contents at a Glance 5
Contents 6
About the Author 13
About the Technical Reviewer 14
Acknowledgments 15
Introduction 17
Who This Book Is For 17
How This Book Is Structured 17
Prerequisites 19
Downloading the Code 19
Contacting the Author 19
The Service Broker Programming Model 20
Fundamentals of Message- Based Processing 21
Message Concepts 22
Why Messaging? 24
Messaging Problems 27
Messaging Architectures 30
Available Messaging Technologies 32
Summary 34
Introducing Service Broker 35
Conversations 35
Anatomy of a Service 40
Security 44
Message Processing 46
Performance 47
Benefits 49
Summary 49
Service Broker in Action 50
Defining Service Broker Applications 50
Message Types 51
Contracts 54
Queue 58
Service 60
Sending Messages 64
Retrieving and Processing Messages 70
Retrieving Messages 71
Processing Messages 74
Error Handling 79
Summary 89
Service Broker Activation 90
Activation Basics 90
Internal Activation 94
External Activation 120
Parallel Activation 136
Troubleshooting Activation 141
Summary 143
Service Broker with Managed Code 144
The Managed Assembly 145
Architecture and Design of the Managed Assembly 148
Building a Managed Service Broker Client 154
Building a Managed Service Program 160
A Practical Example 168
Summary 178
Locking and Transaction Management 179
Conversation Groups and Locks 179
Transaction Management 238
Summary 254
Distributed Service Broker Applications 255
Communication 255
Routing 258
Distributed Applications 262
Summary 283
Advanced Service Broker Programming 285
Advanced Distributed Service Broker Programming 286
Transport Security 287
Dialog Security 290
Encryption 302
Transport Protocol 305
Replacing Certificates 309
Service Listing Manager 311
Summary 319
Service-Oriented Database Architecture 320
Service-Oriented Database Architecture 320
Data in SODA 323
SODA Features in SQL Server 2008 326
Summary 365
Real-World Application Scenarios 366
Reliable Web Service Requests 367
Asynchronous Triggers 391
Workflow-Driven Service Broker Solutions 401
Batch Frameworks 423
Publish-Subscribe Frameworks 435
Workload Throttling Through Service Broker 445
Priority-Based Message Processing 460
Summary 474
High Availability and Scalability 475
Database Mirroring 476
Load Balancing 484
Message Forwarding 488
Configuration Notice Service 497
Data-Dependent Routing 504
Summary 525
Administration 526
SQL Server Management Studio 526
System Monitor 538
SQL Server Management Objects 543
Troubleshooting 547
Summary 562
Index 563