Allow using Query Notifications with Azure SQL Databases
Please allow using Query Notifications with Azure SQL Databases.
In combination with OutputCache having SqlDependency set the Query Notifications mechanism should reduce web sites load and increase pages response time.
This is not currently planned at this time. Will keep this item open for voting and comments.
We need this type of functionality to be available before we can fully migrate to Azure.
David Smith commented
Many of the comments on the "Enable SQL Service Broker in SQL Azure" post expressed the need for functionality provided by SqlDependency. We need this type of functionality to be available before we can fully migrate to Azure.
Ken Cox commented
This has been "under review" for a long time now.
Stijn Spijker commented
I would also like this feature to be able to replicate certain tables / columns to a REDIS store to increase performance for our cloud solutions.
Kevin Christensen commented
If Service Broker support was added, Query Notification would be another nice feature.