ANSI ISOLATIONS levels are very important part of any database. There are two database servers both have different isolations levels. Due to the same different results are returned to the users. Let us help them by educating regarding various isolations levels and their various behaviors with example. What are the different ANSI ISOLATION Levels? What is the additional ISOLATION Level with SQL Server and explain its behavior?

This VB.NET code snippet demonstrates the basic code required to save a disk file into a FILESTREAM database using VB.NET

Just learned that the matching datatype for sql datatype TINYINT in Microsoft .net Framework is BYTE

'And' operator evaluates both expressions, 'AndAlso' evaluates the right side only if the left side is true. For example, below code throw exception if StrandalsoTest is nothing

While handling multiple results in TSQL is not possible, it is easily possible in front end tools like VB6, .NET, etc. Here is an example for it. Consider rs is the recordset that retreives multiple resultsets from a stored procedure...

Recently I was playing with HTML5 and I was in need of the HTML5 intellisense in Visual Studio 2010. I found a great extension which will provide me a great intellisense for HTML5. I thought its great to share with you all.  You can download that tool from following link. http://visualstudioga...

Task list is a great feature of visual studio and I think its most unappreciated features of Visual Studio 2010 and most of developers are not aware of it or don’t know about it and that’s why they are not using it. So I decided to write  blog post about it. As .NET Developer we spend lots of...

{3}", className, generic, methodName, msg.ReturnValue); Console.WriteLine("PostMethodCalling: " + postMethodMessage); //Logging Logger.Instance.Log(postMethodMessage); return msg; } public bool WillExecute { get { return true; } } } public class DAL : AOPExa...

I am covering unit testing with mock objects using Rhino mock .net library. What is unit Test? It is a method of testing a smallest unit of source code. Unit can be function or method. Unit tests are created during development process by develo...

Microsoft Visual Studio 2010 comes with great UML Features I will explain them in details in future post. But In this post I am going to explain the UML concepts because its necessary to understand UML concepts before moving to Visual Studio 2010 part. I know this post may sound very basic to some o...