An AlwaysOn Bug with Service Broker Transmission Queue
Paul Brewer talks about an AlwaysOn problem affecting the Service Broker Transmission Queue.
2014-01-07
4,536 reads
Service Broker (SSSB)
Turbocharge Your Database Maintenance With Service Broker: Part 2
I demonstrate how to monitor and troubleshoot Service-Broker-task execution in the context of a database-maintenance process.
2013-11-11
5,043 reads
An Introduction to SQL Server Service Broker
Service Broker is a technology built into SQL Server and utilized by the engine for its internal asynchronous processing. The great thing about Service Broker is that its functionality is exposed so we can build our own custom data integrations. Deanna Dicken introduces you to the concepts needed to create a service broker integration.
2012-07-30
3,492 reads
Turbocharge Your Database Maintenance With Service Broker: Part 1
Are your maintenance windows too wide? Find out how to shrink them with Service Broker.
2012-07-09
8,923 reads
SQL Server 2012 - New Service Broker Features
SQL Server 2012 came with bells and whistles for service broker, that give you plenty reasons to start using service broker in your applications.
2012-06-29
4,179 reads
2012-03-02
2,139 reads
2011-12-15
14,386 reads
Managing SQL Server Service Broker Environments
SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.
2011-07-21
2,085 reads
Understanding SQL Server Service Broker Authentication
Arshad Ali outlines different types of authentication modes for communicating across SQL Server Service Broker (SSBS) services.
2011-06-14
2,937 reads
Asynchronous Procesing with Service Broker
Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.
2011-05-17
10,966 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers