Category Archives : Features


SQL Server Service Broker – Conversation Architecture

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine. Previous posts: SQL Server Service Broker – Introduction SQL Server Service Broker – Service Architecture In this installment, we introduce Service Broker’s conversation architecture. Conversations […]


SQL Server Service Broker – Service Architecture

This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queuing technology built into the SQL Server Database Engine. Previous posts: SQL Server Service Broker – Introduction In this installment, we introduce the basic Service Broker service architecture components. Taxes Before I jump into […]


SQL Server 2014 – Delayed Durability

Pop quiz: What does ACID stand for? That should be a pretty easy question for database professionals: Atomicity Consistency Isolation Durability It’s that last property, durability, that I want to talk about today. Durability guarantees that, when a transaction is committed, it stays committed. The changes made by that transaction are permanent, even in the […]

Delayed Durability log flush