We recently tried using SQL Server Query Notification (aka SQL Cache Dependency) for something much more involved than the usual “lookup table” (using it to send relevant data updates from a large OLTP system into a secondary aggregating system).
It’s been a whirlwind of “I’m impressed” moments (with a share of little snags too).
Here’s what we were impressed by:
