SQL Server Service Broker provides the SQL Server Database Engine native support for messaging and queuing applications. This makes it easier for developers to create sophisticated applications that use the Database Engine components to communicate between disparate databases. Developers can use Service Broker to easily build distributed and reliable applications." This is according to the Technet reference found here. SQL Server Service broker was introduced in SQL Server 2005. After more than 7 years of its existence SQL Server Service broker remains a gray area to most SQL Server developers. Below are cases where service broker can be use. Table of Contents Introduction
Real Life Scenario.
Service Broker to the rescue.
Why not SSIS?
Why not Replication then?
Service Broker Step By Step
1. Know Where Service Broker is in SQL Server Management Studio?
2. How to Enable Service broker in the Database?
3. How to create a message type?
4. Create a Contract
5. Create Sender and Receiver Queue
6. Create Sender and Receiver Services
7. Send a message to the Queue.
7. View the message without removing it from the QueueReal Life Scenario.You are an IT professional in a department store industry named “My-mall”. “My-mall” have 100 point of sale(POS) terminals sitting on top of a SQL Server “sales” database. Sales database is owned by “sales Department”. Sales department critical task is accommodating sales from customer either by payment through credit card, cash, debit card or gift certificates . “My-mall” also have an “inventory” database owned by the “inventory department”. Inventory department critical task is replenishing stocks in the store in a timely manner as well as maintaining the correct inventory of the product. My-mall also has an accounting database owned by the accounting department. Read more: Greg's Cool [Insert Clever Name] of the Day
Read more: SQL Server Service Broker at a Glance
QR:
Real Life Scenario.
Service Broker to the rescue.
Why not SSIS?
Why not Replication then?
Service Broker Step By Step
1. Know Where Service Broker is in SQL Server Management Studio?
2. How to Enable Service broker in the Database?
3. How to create a message type?
4. Create a Contract
5. Create Sender and Receiver Queue
6. Create Sender and Receiver Services
7. Send a message to the Queue.
7. View the message without removing it from the QueueReal Life Scenario.You are an IT professional in a department store industry named “My-mall”. “My-mall” have 100 point of sale(POS) terminals sitting on top of a SQL Server “sales” database. Sales database is owned by “sales Department”. Sales department critical task is accommodating sales from customer either by payment through credit card, cash, debit card or gift certificates . “My-mall” also have an “inventory” database owned by the “inventory department”. Inventory department critical task is replenishing stocks in the store in a timely manner as well as maintaining the correct inventory of the product. My-mall also has an accounting database owned by the accounting department. Read more: Greg's Cool [Insert Clever Name] of the Day
Read more: SQL Server Service Broker at a Glance
QR:
Posts
0 comments:
Post a Comment