--- title: "Yukon \"Query Notification\": a life saver" url: "https://osherove.com/blog/2004/9/6/yukon-quotquery-notificationquot-a-life-saver.md" canonical: "https://osherove.com/blog/2004/9/6/yukon-quotquery-notificationquot-a-life-saver.html" published: "2004-09-06T18:59:00" updated: "2004-09-06T18:59:00" tags: [".Net Original"] author: "Roy Osherove" description: "At the Israeli SQL user group today we had a special visit: Roger Woter - PM at Microsoft. he talked about the Service broker in Yukon. very cool stuff. However I learned a little thing that I think is absolutely…" usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)." license: "https://creativecommons.org/licenses/by/4.0/" --- # Yukon "Query Notification": a life saver By Roy Osherove September 6, 2004 In [.Net Original](https://osherove.com/blog/category/net-original) **Historical article** · Originally published September 6, 2004; technical details may be outdated. At the Israeli [SQL user group](http://www.sql.co.il/) today we had a special visit: Roger Woter - PM at Microsoft. he talked about the Service broker in Yukon. very cool stuff. However I learned a little thing that I think is absolutely fabulous: One of the _coolest_ new features to me in Yukon will be a little thing called "_Query Notification_". What's that? I'll give you a hint. Ever used the ASP.Net _Cache_ object? you know how it has a cache expiry period that can be based upon a time span or a file changing on disk? What's the thing missing most from this functionality? that's right - auto-expiry when the data that you cached changes _in the database_. It's just not there. People have to go through hoops to find out when data has changed. Not anymore. With Yukon you can "signal" to the server with the same query that you used to fetch the data you have in memory, and if any row in one of the tables that is in the query is changed, inserted or deleted (meaning running the query now will yield different results) you'll get an **automatic** notification of this that will be sent to a special queue on which you can listen on and re-cache your query with the new data. no more hopping around trying to know if something changed. **Thank you thank you thank you**. :) ## More in .Net Original [All posts in .Net Original](https://osherove.com/blog/category/net-original) - Sep 9, 2004 ### [How Test Driven Development proved itself in a big way!](https://osherove.com/blog/2004/9/9/how-test-driven-development-proved-itself-in-a-big-way.html) - Sep 8, 2004 ### [See you at the .Net on the beach convention](https://osherove.com/blog/2004/9/8/see-you-at-the-net-on-the-beach-convention.html) - Sep 3, 2004 ### [.Net Blogger geek meets Eric Rudder, asks questions, gets answers, is happy](https://osherove.com/blog/2004/9/3/net-blogger-geek-meets-eric-rudder-asks-questions-gets-answe.html) - Sep 3, 2004 ### [WilsonORMapper at version 3.0, and what's an OR mapper anyway?](https://osherove.com/blog/2004/9/3/wilsonormapper-at-version-30-and-whats-an-or-mapper-anyway.html) --- ## About the author **Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery. ### Sites - [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership. - [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts. - [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin. - [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model. - [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps. - [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes). ### Social - X: https://x.com/royosherove - LinkedIn: https://www.linkedin.com/in/osherove/ ### Contact - Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7 ### License Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/