January 13th, 2013

Database Change Notifications in ASP.NET using SignalR and SqlDependency

This article shows how to display real time sql server database change notification in ASP.NET using SignalR and SqlDependency object which represents a query notification dependency between an application and an instance of SQL Server. Consider your database is updated or synchronized by windows service in background, you have to display real time updated data. This article explains how to implement it.
Read More Database Change Notifications in ASP.NET using SignalR and SqlDependency

April 5th, 2012

SQL Query To Check Money Data Type and Convert it to Decimal Dynamically

Sometimes we need to convert one data type to another data type to map columns in sql server. You might not be allowed to change table structure directly. In this case you’ve to convert in your query or stored procedure. Suppose you’ve to convert money data-type to decimal for greater precision in calculation then you can do it easily using Cast or Convert methods. Read More SQL Query To Check Money Data Type and Convert it to Decimal Dynamically