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 […]