4 posts in Database

Defeating deadlocks with READ_COMMITTED_SNAPSHOT isolation

Adam Cooper /

I was recently asked by a client to look into an issue they were having with a WCF web service. The application was generating a large number of errors, filling a 5MB log file every 5 minutes, and the performance of the underlying database was so bad that a simple query such as: SELECT COUNT (*) FROM Address would take up to a minute and a half to return. Checking the…

Enable Service Broker taking forever

Adam Cooper /

Today I had to enable Service Broker in SQL 2008 because when using a SqlCacheDependency I was getting the error: The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications. This should be pretty easy just using the following command: ALTER DATABASE 'DatabaseName' SET ENABLE_…

SubSonic is out

Adam Cooper /

I’ve been a big fan of SubSonic for a while now, as you can probably tell from my last post and I’ve been helping out with the project a lot more over the last few months. Yesterday all the hard work paid off and we’ve released version to the world, see Rob’s blog for more details of what’s included. There’s…

Seven reasons you should try SubSonic

Adam Cooper /

SubSonic is a query tool for .Net data access. If you haven’t tried it out then you really should and here’s why: It’s simpler than, for example, nHibernate Don’t get me wrong I like nHibernate a lot it’s amazingly powerful, flexible and mature. I’ve worked with it on many projects and admire it a great deal. But if you want to go from nothing…

Success! Your account is fully activated, you now have access to all content.
Success! Your billing info is updated.
Billing info update failed.