Service Broker (SSSB)

Technical Article

Building the MSDN Aggregation System

  • Article

After agreeing on our design goals we began looking for technologies to support them. It turned out that SQL Server™ Service Broker offered the asynchronous messaging support we needed and, since the message-queuing infrastructure is tightly integrated with the SQL Server database engine, our existing database backup, administration, and failover procedures could cover our messaging solution as well.

2006-07-26

1,736 reads

SQLServerCentral Article

The SQL Server Postal Service

  • Article

One way to understand Service Broker is to think of it as a postal service. New author Sachin Dedhia brings us a fantastic introduction to the Service Broker including the code to setup and begin working with queues, conversations and contracts. If that doesn't make sense, you need to read this article.

5 (1)

You rated this post out of 5. Change rating

2006-05-08

9,795 reads

SQLServerCentral Article

An Introduction to the Service Broker Part 2

  • Article

One of the less exciting, but perhaps very powerful new features in SQL Server 2005, the Service Broker is an asynchronous communications method. MVP Srinivas Sampath brings us the second part of his series looking at what you can accomplish with a practical example.

4.75 (4)

You rated this post out of 5. Change rating

2005-08-30

13,118 reads

Blogs

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

SQL Server Migration Overview

By

It’s Not Just Backup / Restore At some point every company faces it: the...

Trace Flag 1448 – Lessons from a Technical Interview

By

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Can/Can't Do/Don't

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can/Can't Do/Don't

Strange String Splits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Strange String Splits

Visit the forum

Question of the Day

Strange String Splits

When I run this code, how many rows are returned?

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

See possible answers