I came across a situation where I had to find all the stored procedures or user defined functions that do not have “execute” permission under a particular user. Here is a simple SQL Statement one which can be used under SQL Server 2005 to find those objects. [More]

It is very important to evaluate the most efficient way of passing data between layers. Many people recommend using ArrayList, some Generic List. But which one is the most efficient way to use? I thought to perform a speed test between Generic List and ArrayList in VS2005. Some people blindly accept that ArrayList is the fastest way. But is it true? Let’s have a real test by reading and writing hundred thousand records using each type and see the outcome. Knowing the fact that Collection, Data Table and XML is slower than these two but how much? Let’s put them to test too and compare the result. [More]

It has been always a challenge in a development team to come up with a Standard Code Review Template for .NET. I struggled with the same issue and hence researched on the web to find out some code review guidelines which can help each developer and development team to evaluate those important criteria for a better development practice. This template also provides some important links to a developer to follow as a set of guidelines based on standard practices. [More]