Useful Tips

I am trying to list some useful commands, tips that are rarely needed and need to search on the web. Please add your tips on comment so that i can update this page continuously. Share This:

Read more

Converting Visual Studio 2012 solution to Visual studio 2008/2010

Problem: When we go on web for solution of some problem, and people on internet can provide us with the whole project or solution.  Not every developer uses the same version of Visual studio IDE.  Situation could be something like that, you are using visual studio 2010 and solution provided on web is […]

Read more

View row count of multiple tables with single query

I got myself in the situation, where I needed to find the row count of multiple large tables. Executing count(Fieldname) for these large tables was not a right choice, so I opted to use sysindexes. Then, I came up with the idea of joining sysindexes and sysobjects. Here is the […]

Read more

Backup all SQL Server database at once

Problem Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks.  One of these tasks may be the need to backup all databases on your server.   This is not a big deal if you have […]

Read more

Searching XML content using LINQ in .net

I’m impressed with the features of Linear Query and it’s reliability. I wonder myself on solving few problems that weren’t solved using other techniques are solved using LINQ myself. Before starting detail LINQ tutorial did you check my last Post about LINQ? It not Check it here. Well, no more […]

Read more