Watch the SqlNotificationInfo for query notifications
I've been back working with SQL Server Query Notifications again lately. This blog post stems from a problem where the query notification "appears to register
I've been back working with SQL Server Query Notifications again lately. This blog post stems from a problem where the query notification "appears to register
The companion whitepaper to my "Planning, Implementing, and Administering Scaleout Solutions with SQL Server 2005" whitepaper (see yesterday's post) is available. This whitepaper is called
I've been working on some whitepapers on scaleout technologies in SQL Server 2005. The first whitepaper is now available; I don't have the main link,
Last week at TechEd I was showing off Query Notifications. When I showed using the preprovisioned queue (overloads on SqlDependency.Start and SqlDependency constructor), a delegate
In helping out with a project involving ASP.NET 2.0's cache sync feature, which has best performance when built on SQL Server 2005's Query Notifications, I
I've answered a few questions lately on setting up SqlDependency or ASP.NET SQL Server dependency with SQL Server 2005. Folks have gone by the instructions
I'm headed out on the road. For quite a while. Wanted to settle this before I went. Looks like the implementation details of SqlDependency have
I've been wondering what happened to the QueryNotification dispatcher proc that's used by SqlDependency in ADO.NET (and in ASP.NET with SQL Server 2005). The one
In the April CTP of .NET 2.0, I chanced upon some changes to SqlNotificationRequest, using my favorite tool, .NET Reflector and my one my favorite
Last week I promised some of my students that I had an article in the works on the intricacies of SQL Server 2005/.NET 2.0 Query
There have been a number of questions recently (well OK, three) on the beta newsgroups about SqlDependency problems. It's been suggested that SqlDependency doesn't work
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
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.