2 ms·

I am doing the same with SQL Server. The messages table is more of a bus than a queue in our case (columns like ReplyToId, etc). Using it for RPC communication

I am doing the same with SQL Server. The messages table is more of a bus than a queue in our case (columns like ReplyToId, etc). Using it for RPC communication between cloud bits. Much cheaper than Azure Service Bus and friends.

deleted 3y ago
[deleted]
Digit-Al 3y ago
Just out of interest: any reason you're not using the SQL server service broker?
- bob1029 3y ago
  It's only available in managed instances or on-prem. We are trying to use the "serverless" flavor of Azure SQL throughout: https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql https://learn.microsoft.com/en-us/azure/azure-sql/database/f...
  - Digit-Al 3y ago
    Ah, okay. Cheers for the reply.
- nickpeterson 3y ago
  I don’t know the OPs answer, but I’d hazard to guess because ssmb is a completely neglected feature with very little in the way of community or UI. In theory it would be great, but MS basically never invested in it after its release and now it’s just a random, “who knows when we’ll drop support for this” sql server feature.