I'm not sure if this is 'hard-hat' enough, but here goes.
I was doing some work with the Speech Application Framework when I ran into Sql Notification services.
I got a little excited about it, installed it and ran thorugh the tutorials. Around lesson 8 or so I was becoming underwhelmed. It seemed like a large amount of work to simply raise database driven events.
I've come to notice that whenever I'm 'underwhelmed' with something, its usually that I'm missing something.
Have any of you used SQl Notificaton servies? If so, how have you found it useful? Compared to rolling your own solution?