#title Service Broker
[[TableOfContents]]

필자가 Microsoft SQL Server 2005가 나왔을 때에 가장 관심을 가진 것이 Service Broker다. 처음에는 너무나 낯설어서 Service Broker에 학습이 쉽지가 않았다. 특히나 인증서 기반의 원격 서버간의 데이터를 주고 받는 일은 정말 쉽지 않았다. 아쉬운 것은 현재[* 2008년 01월]까지 Service Broker를 이용한 여러 성공사례들이 없다는 것이다. 잘만 하면 코딩량이 꽤 줄어들 것인데 말이다. 

==== 목차 ====
 * [Service Broker의 개념]
 * [간단한 메시지 송/수신 예제]
 * [Service Broker를 이용하여 응답속도 높이기]
 * [원격 서버간 메시지 주고 받기]
 * [DDL 비동기 트리거 구현]
 * [성능최적화-기본편]
 * [성능최적화-150trick]
==== Technical Article ====
 * [http://www.sqlpassion.at/blog/PermaLink,guid,593e289f-2a01-43ad-bb60-b57f817d9752.aspx Service Broker Adventures: Stucked Queue Monitors]
 * [http://www.databasejournal.com/features/mssql/managing-sql-server-service-broker-environments.html Managing SQL Server Service Broker Environments]
 * [http://www.sqlservercentral.com/articles/Service+Broker/73398/ Asynchronous Procesing with Service Broker]
 * [http://www.databasejournal.com/features/mssql/understanding-sql-server-service-broker-authentication.html Understanding SQL Server Service Broker Authentication]
 * [http://www.mssqltips.com/tip.asp?tip=2309 SQL Server Service Broker Poison Message Handling]
 * [sys.transmission_queue에서 대화종료하기]
 * [http://msftsbprodsamples.codeplex.com/ SQL Server Service Broker Product Samples]
 * [http://www.databasejournal.com/features/mssql/article.php/3927721/article.htm Conversation Priorities]
 * [http://www.databasejournal.com/features/mssql/article.php/3896201/article.htm Writing an SSBS App When the Initiator and Target are on the Same Database]
 * [http://www.codeproject.com/KB/database/asynchronousTSQL.aspx Asynchronous T-SQL Execution Without Service Broker]
 * [http://www.sqlmag.com/Articles/Index.cfm?ArticleID=103131 Managing Service Broker Conversations]
 * [http://www.sqlservercentral.com/articles/Service+Broker/67513/ Step by Step how to setup Service Broker in Single Database]
 * [http://msdn.microsoft.com/en-us/library/dd576261.aspx Performance and Scalability Techniques]
 * [http://www.databasejournal.com/features/mssql/article.php/3808556/Service-Broker-Poison-Message-Handling.htm Service Broker Poison Message Handling]
 * [http://msdn.microsoft.com/en-us/library/dd576261.aspx Service Broker: Performance and Scalability Techniques]
 * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1361199_mem1,00.html Setting up SQL Server Service Broker for secure communication]

==== 참고자료 ====
 * Inside SQL Server 2005 T-SQL Programming, 정보문화사
 * The Rational Guide to SQL Server 2005 Service Broker Preview
 * A First Look at SQL Server 2005 For Developers
 * books on-line
 * 기타 MS자료 및 웹사이트 자료들