Just when I thought I'd found all the new cool features. An Ascend Phase 1 participant once asked me “can the DBA get rid of unwanted query notification subscriptions”? In Beta2 you can.
SELECT * FROM sys.dm_qn_subscriptions
— pick the ID of the subscription that you want, then
— say its ID = 42
KILL QUERY NOTIFICATION SUBSCRIPTION 42
Cool. Your subscriber app doesn't appear to get notified its been killed, though, (as it does when almost anything else affecting the subscription happens) either when using SqlDependency or SqlNotificationRequest . That's why this should only be used for “pesky” subscriptions.