Jon, I love your videos for their content. They are very informative. I also like your delivery style. Thanks for sharing your expertise! Keep up the good work.
Thanks for the informative video, I like the way you deliver the information - straight to the point. Back in 2005 I was excited by Service Broker (SB) intro, but actual implementation found cumbersome and we stopped supporting SB. Question: in these days (2018) how would you build asynchronous SQL queries processing? Would you still consider SB for messaging?
It depends on the business requirements and what needs to go where. Certainly there are advantages and disadvantages of Service Broker, so... it depends. But I would definitely consider it as an option, especially since it's functionality built into a product that will already be in use in the organization.
I am happy to know service broker. But SCALEOUT is a totally different concept. This means attaching more outsided resources to handle the load. You have not spoken on that point. How service broker can help on-demand in that regard?
(I'm assuming that was directed at me.) The short answer is that my previous job burned me out doing database stuff, and my new job (since Feb 2015) is in a different field. A lot of the small technical details are gone now. I may come back to this from a different angle in the future, making the occasional reference-style content video, like the last few were.
Thank you for posting this video. I'm wanting to do distributed computing. Right now, our system is dumping into a SB Queue and it activates several threads to process the queue inside of SQL Server. However, the CLR that it is calling downloads HTML from a website and sends it to an SMTP server. For whatever reason, this is much slower than taking the processing outside of SQL Server. I would like to write a distributed .NET Core app that works on the existing queue and make sure that it does not duplicate the work. Our customers do not want to receive multiple emails and they definitely want their email. Before, I relied a lot on SB to handle all of that and now I'm not sure what would happen if one external app received an item and started processing, but didn't complete. I've been searching for applications that have used SB and it is very hard to find them. They almost always use RabbitMQ. What are your thoughts?
Hi there. This is nice video but very low informative. After 13:38 min I still don't know what Service Broker is and what is the purpose of using it. You are talking like a robot or bored teacher on the same 1001 presentation. Please explain what Service Broker is, what is his purpose in general in simple words, put some simple non-technical diagram of it - like "if there is a 100 application, service broker is able to parallel the request from application or balanced the resources between application requests". In way that almost every technical person will understand. Not only some "few geek developers from your room in school". Come on, it's a video for people. BR,
Hi Borka, Everything is fine; thanks for asking. I've just been taking a break from this and working on other projects (not DBA-related). Don't worry, I do intend to make more videos on this channel. :) I also post on dba.stackexchange.com regularly if you haven't seen that site before.
Voluntary DBA Thank you for answering and providing additional info - much appreciated! It's nice to hear that you are fine! Looking forward to seeing new videos :) Take care! -- Borka
It sounds like Service Broker could be customized to create a custom company-wide trouble-ticket/change control system when used in coordination with an sql server database. Kewl.
Oh, and put some energy and positive attitude in your videos. Talking like a robot without any intonation is very hard to listening and understand above 1-2 minutes.
Jon, I love your videos for their content. They are very informative. I also like your delivery style. Thanks for sharing your expertise! Keep up the good work.
Thank you! This can still be an awesome feature in 2020.
Awesome video. It's kicking Pluralsight's backend 😀.
Thanks for the informative video, I like the way you deliver the information - straight to the point.
Back in 2005 I was excited by Service Broker (SB) intro, but actual implementation found cumbersome and we stopped supporting SB.
Question: in these days (2018) how would you build asynchronous SQL queries processing?
Would you still consider SB for messaging?
It depends on the business requirements and what needs to go where. Certainly there are advantages and disadvantages of Service Broker, so... it depends. But I would definitely consider it as an option, especially since it's functionality built into a product that will already be in use in the organization.
Video suggestion: High availability setup and config start to end
Great video. Very explanatory and clear. Thank you!
I am happy to know service broker. But SCALEOUT is a totally different concept. This means attaching more outsided resources to handle the load. You have not spoken on that point. How service broker can help on-demand in that regard?
It's possible to send messages to a different database on a different server.
Hi, why did you stop uploading videos? they are all so useful.
(I'm assuming that was directed at me.) The short answer is that my previous job burned me out doing database stuff, and my new job (since Feb 2015) is in a different field. A lot of the small technical details are gone now. I may come back to this from a different angle in the future, making the occasional reference-style content video, like the last few were.
Thanks ! Looking forward on this.
Thank you for posting this video. I'm wanting to do distributed computing. Right now, our system is dumping into a SB Queue and it activates several threads to process the queue inside of SQL Server. However, the CLR that it is calling downloads HTML from a website and sends it to an SMTP server. For whatever reason, this is much slower than taking the processing outside of SQL Server. I would like to write a distributed .NET Core app that works on the existing queue and make sure that it does not duplicate the work. Our customers do not want to receive multiple emails and they definitely want their email. Before, I relied a lot on SB to handle all of that and now I'm not sure what would happen if one external app received an item and started processing, but didn't complete.
I've been searching for applications that have used SB and it is very hard to find them. They almost always use RabbitMQ.
What are your thoughts?
why aren't you uploading now?
Hi there. This is nice video but very low informative. After 13:38 min I still don't know what Service Broker is and what is the purpose of using it. You are talking like a robot or bored teacher on the same 1001 presentation. Please explain what Service Broker is, what is his purpose in general in simple words, put some simple non-technical diagram of it - like "if there is a 100 application, service broker is able to parallel the request from application or balanced the resources between application requests". In way that almost every technical person will understand. Not only some "few geek developers from your room in school". Come on, it's a video for people. BR,
Hi there! We have not heard from you quite for a long. Is all alright?
-Borka
Hi Borka,
Everything is fine; thanks for asking. I've just been taking a break from this and working on other projects (not DBA-related). Don't worry, I do intend to make more videos on this channel. :) I also post on dba.stackexchange.com regularly if you haven't seen that site before.
Voluntary DBA Thank you for answering and providing additional info - much appreciated! It's nice to hear that you are fine! Looking forward to seeing new videos :) Take care! -- Borka
It sounds like Service Broker could be customized to create a custom company-wide trouble-ticket/change control system when used in coordination with an sql server database. Kewl.
thanks:)
broker services receiving requsest and sending and used sql and database
Oh, and put some energy and positive attitude in your videos. Talking like a robot without any intonation is very hard to listening and understand above 1-2 minutes.
For God's sake, next time put the camera far away and speak naturally.
It felt like Siri just got a human body!
Next time, dont leave a comment.