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 fast 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 What you’ll learn Understand the fundamentals of message–based processing. Install Service Broker and manage the environment. Design databases for service–oriented applications. Develop distributed applications. Build in scalability and high availablity. Apply best practices to avoid future trouble. Who is this book for? Pro SQL Server 2008 Service Broker is written for new and existing users of Service Broker who wish to develop service–oriented and distributed transactions that scale well, that are resilient against failure, and that are as future–proofed as possible from the application of current best practices in Service Broker development. About the Apress Pro Series The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder. You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
Author(s): Klaus Aschenbrenner
Edition: 1
Year: 2008
Language: English
Pages: 600
Contents......Page 6
About the Author......Page 13
About the Technical Reviewer......Page 14
Acknowledgments......Page 15
Introduction......Page 17
PART 1: The Service Broker Programming Model......Page 20
CHAPTER 1: Fundamentals of Message-Based Processing......Page 21
Message Concepts......Page 22
Why Messaging?......Page 24
Messaging Problems......Page 27
Messaging Architectures......Page 30
Available Messaging Technologies......Page 32
Summary......Page 34
Conversations......Page 35
Anatomy of a Service......Page 40
Security......Page 44
Message Processing......Page 46
Performance......Page 47
Summary......Page 49
Defining Service Broker Applications......Page 50
Message Types......Page 51
Contracts......Page 54
Queue......Page 58
Service......Page 60
Sending Messages......Page 64
Retrieving and Processing Messages......Page 70
Retrieving Messages......Page 71
Processing Messages......Page 74
Error Handling......Page 79
Summary......Page 89
Activation Basics......Page 90
Internal Activation......Page 94
External Activation......Page 120
Parallel Activation......Page 136
Troubleshooting Activation......Page 141
Summary......Page 143
CHAPTER 5: Service Broker with Managed Code......Page 144
The Managed Assembly......Page 145
Architecture and Design of the Managed Assembly......Page 148
Building a Managed Service Broker Client......Page 154
Building a Managed Service Program......Page 160
A Practical Example......Page 168
Summary......Page 178
Conversation Groups and Locks......Page 179
State Handling......Page 186
Transaction Management......Page 238
Summary......Page 254
Communication......Page 255
Routing......Page 258
Distributed Applications......Page 262
Summary......Page 283
PART 2: Advanced Service Broker Programming......Page 285
CHAPTER 8: Advanced Distributed Service Broker Programming......Page 286
Transport Security......Page 287
Dialog Security......Page 290
Encryption......Page 302
Transport Protocol......Page 305
Replacing Certificates......Page 309
Service Listing Manager......Page 311
Summary......Page 319
Service-Oriented Database Architecture......Page 320
Data in SODA......Page 323
SODA Features in SQL Server 2008......Page 326
Summary......Page 365
CHAPTER 10: Real-World Application Scenarios......Page 366
Reliable Web Service Requests......Page 367
Asynchronous Triggers......Page 391
Workflow-Driven Service Broker Solutions......Page 401
Batch Frameworks......Page 423
Publish-Subscribe Frameworks......Page 435
Workload Throttling Through Service Broker......Page 445
Priority-Based Message Processing......Page 460
Summary......Page 474
CHAPTER 11: High Availability and Scalability......Page 475
Database Mirroring......Page 476
Load Balancing......Page 484
Message Forwarding......Page 488
Configuration Notice Service......Page 497
Data-Dependent Routing......Page 504
Summary......Page 525
SQL Server Management Studio......Page 526
System Monitor......Page 538
SQL Server Management Objects......Page 543
Troubleshooting......Page 547
Summary......Page 562
A......Page 563
B......Page 564
C......Page 565
D......Page 568
E......Page 569
H......Page 570
L......Page 571
M......Page 572
O......Page 574
P......Page 575
Q......Page 576
R......Page 577
S......Page 578
T......Page 584
W......Page 586
Z......Page 587
