Jul 19
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]
Tags:
Jul 08
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]
Tags: |
Jul 05
It has been 20 years since the concept of Enterprise Architecture was first introduced in IT industry to provide an Enterprise Solution. I got an opportunity to present my thoughts on Architecture, Design and Patterns for Enterprise Solution. In this presentation, I have tried to cover the architecture which were followed in the past as well as currently being used now in this evolving IT industry. Thus, it also covers the new paradigm of developing an application where main IT players such as Microsoft, Sun etc. are suggesting and implementing the new architecture which looks like the best solution of IT industry today.. [More]
Jul 02
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]
Tags: