Asynchronous real-time web development with SignalR

SignalR is a library used in.NET to build real-time web applications. Following articles will give you a starting point to development with SignalR

1. http://www.hanselman.com/blog/AsynchronousScalableWebApplicationsWithRealtimePersistentLongrunningConnectionsWithSignalR.aspx

2. http://www.msguy.com/2011/11/real-time-push-notifications-with.html

3. http://sanketakulkarni.blogspot.com/2012/04/developing-real-time-application-with.html

If there are any issues in running the sample refer 3rd link in the above list. In addition when you are deploying this in IIS following enttries should be added to web.config.

<configuration>
   <system.webServer>
        <validation validateIntegratedModeConfiguration="false" />
        <modules runAllManagedModulesForAllRequests="true">
        </modules>
    </system.webServer>
</configuration>
Cheers
Samitha

SQL View: Beyond the Basics

This article discusses cool stuff beyond the basics of how with check option" works

http://www.simple-talk.com/sql/t-sql-programming/sql-view-beyond-the-basics/

cheers
samitha

Indexed view deadlocking

Following article provide some insight into tracking down deadlocks.

http://www.sqlservercentral.com/blogs/dave_ballantynes_blog/2012/06/13/indexed-view-deadlocking/

cheers
samitha