What exactly is SQL Server 2005 Service Broker? - Data warehousing

What exactly is SQL Server 2005 Service Broker?

Servive brokers allow build applications in which independent components work together to accomplish a task. They help build scalable, secure database applications. The brokers provide a message based communication and can be used for applications within a single database. It helps reducing development time by providing an enriched environment.

What exactly is SQL Server 2005 Service Broker?

Scalable, secure database applications can be developed by using SQL Server 2005 Service Broker. Apart from Database Engine, message-based communication platform is provided which enables the independent application components to perform as a functioning. Service Broker includes an infrastructure for asynchronous programming. This could be used for applications for single database as well as for distributed applications. The application development time will be reduced by providing the necessary infrastructure for building distributed applications.
Explain the Service Broker components - Data warehousing
Service broker components help build applications in which independent components work together to accomplish a task.....
What is a breakpoint in SSIS? How is it setup? How do you disable it?
Breakpoints allow the execution to be paused in order o review the status of the data, variables and the overall status of the SSIS package....
Concepts and capabilities of Business Intelligence
Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks....
Post your comment