SqlDependency.Start ( ) – Key was not present in disctionary


While using SqlDependency.Start(), I was getting “‘The given key was not present in the dictionary.'” error. I didn’t know what’s the problem but i tried stopping it before i start the new instance but no luck. After some research i found this SQL to use to clear out all queue instances so we can start new one.

DECLARE item_cursor CURSOR LOCAL FAST_FORWARD FOR
    SELECT s.conversation_handle FROM {{dbname}}.dbo.{{queuename}} s LEFT JOIN sys.conversation_endpoints e ON e.conversation_handle=s.conversation_handle WHERE e.conversation_handle IS NULL;
 -- or completely clear it below
 --SELECT s.conversation_handle FROM clients.dbo.MySBQueueName s;
OPEN item_cursor
DECLARE @conversation UNIQUEIDENTIFIER
FETCH NEXT FROM item_cursor INTO @conversation
WHILE @@FETCH_STATUS = 0 
BEGIN
    END CONVERSATION @conversation WITH CLEANUP
    FETCH NEXT FROM item_cursor INTO @conversation
END

Text to speech (tts) for Web


Modern browsers are using Speech Recognition and TTS using Web Speech API.

https://scotch.io/tutorials/building-text-to-speech-apps-for-the-web
http://jsfiddle.net/aybalasubramanian/y8c38b3k/
https://codesandbox.io/s/rmloxx60q4
https://codepen.io/SteveJRobertson/pen/emGWaR
https://github.com/kripken/speak.js
https://www.npmjs.com/package/@kamiazya/ngx-speech-recognition
https://auth0.com/blog/rxjs-advanced-tutorial-with-angular-web-speech-part-1/