Visual Studio 2012 Update 3 CTP has been released by Microsoft

If we don’t take care about how we feed our ASP .net pages… we will find that they will tend rapidly to gain too much weight, this can provide us a lot of headaches. Let's see how to reduce the size of our pages.

How SQL Server 2008 MERGE statement locking compares to the locks held when doing "update if exists, insert if not" problem in SQL Server 2005.

This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard t...

You’ve got a table which contains some information and you want to perform calculations based on this information and store them in the same table or in another table. The calculations must always be up-to-date. The calculations are performed via a complex User Defined Function which accepts t...