Home /

| RSS

Announcing vNext User Group

As developers we are always excited about latest technologies, and as a developer working in Microsoft eco-system there is no shortage of new tools and technologies. This is the driving point behind starting vNext User Group. The group aims to share knowledge about offerings from Microsoft which are in pipeline i.e they are to be [...]

[ More ] April 29th, 2009 | 8 Comments | Posted in News |

SSMS Tools For SQL Server 2008

SSMS Tools Pack is a must have add-in for SQL Server Management Studio. It comes packed with a great set of features which as the author says on his site “…were missing from Management Studio”. Here is run down of three features I use most.
Text Format
If SSMS Tools Pack had only one feature and [...]

[ More ] April 27th, 2009 | No Comments | Posted in Programming |

Outlook 2007 Hotfix

If you have been having issues with Outlook 2007 related to performance, erratic behaviour and just annoyance in general then this hotfix maybe what you need. Released in February 2007 the patch fixes many issues which can make working with Outlook 2007 a punishment. I installed it today morning and it’s been working fine and [...]

[ More ] April 27th, 2009 | No Comments | Posted in Tips |

Capture XML In WCF Service

Working on a project where we wrote WCF Services a need was identified to capture the raw xml passed in to the service operation and also capture the reply xml sent back by the service. WCF does not provide such facility out of the box but it can be easily implemented using behaviours. In this [...]

[ More ] April 1st, 2009 | 11 Comments | Posted in Programming |

Get Width And Height Of Image In C#

To get width and height of an image we can use System.Drawing.Image class. This code snippet shows how to retrieve width and height of an image.

string filePath = @"c:\deepak\MeeGo.jpg";
Image img = Image.FromFile(filePath);
 
Console.WriteLine(string.Format("Height: {0}",img.Size.Height));
 
Console.WriteLine(string.Format("Width: {0}",img.Size.Width));

[ More ] March 31st, 2009 | No Comments | Posted in Code Snippets |

Get Windows Registry Size With WMI And C#

Windows Registry Size can be retrieved using WMI objects. This code snippet shows you how to get current size and maximum size for Windows registry.
ManagementObjectSearcher mgmtObjects =
new ManagementObjectSearcher("Select * from Win32_Registry");

foreach (var item in mgmtObjects.Get())
{
Console.WriteLine(string.Format("Current Size: {0}MB", item["CurrentSize"]));
Console.WriteLine(string.Format("Maximum Size: {0}MB", item["MaximumSize"]));
}

 
The output.

[ More ] March 29th, 2009 | No Comments | Posted in Code Snippets |

5 Ways To Remove Conficker Worm

Conficker worm which strikes on April 1st is already being labelled as one of the most dangerous cyber attacks ever. The way this worm works is that it sets up what are known as botnets on computers around the world. The worm goes active on April 1st when it can be used by its creators [...]

[ More ] March 29th, 2009 | 1 Comment | Posted in Tips |

Reverse Array Elements Using C#

In .Net Framework reversing array elements can be done by using Reverse method on Array type. This code snippet shows you how this method can be used to reverse an array.
// Declare an array with 10 elements
int[] numbers = new int[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };

// Output [...]

[ More ] March 26th, 2009 | No Comments | Posted in Code Snippets |

Convert Hexadecimal To Number In C#

To convert a Hexadecimal to a number we can use an overload of Convert.ToInt32 method.

Using the overload I can convert for example hex string “BB” to a number.
int number = Convert.ToInt32("BB", 16);

And the number variable gets assigned value of 187.

[ More ] March 24th, 2009 | No Comments | Posted in Code Snippets |

Get Free Disk Space Using T-SQL

To get free disk space for all physical drives on a machine we can use xp_fixeddrives extended stored procedure. An interesting this about this procedure is that it is not documented in books online.
EXEC xp_fixeddrives

Here is output on my machine.

[ More ] March 24th, 2009 | No Comments | Posted in Code Snippets |

SQL Server 2008 – Get All Indexes In A Database

You’ve got to love sys views in SQL Server. While learning about performance tuning on SQL Server 2008 I wanted to get a list of all Indexes on my database and the answer was as simple as it can be. Here i a statement which can be used to get a list of all indexes [...]

[ More ] March 24th, 2009 | No Comments | Posted in Code Snippets |

Create T-SQL CASE Statements With LINQ To SQL

I was recently helping Nosh with a LINQ To SQL query where he wanted the resulting T-SQL query to have CASE statements. Having CASE statements in T-SQL queries is a common scenario but how do we it in LINQ To SQL .After some investigation I found the solution which I am presenting here using an [...]

[ More ] March 24th, 2009 | 1 Comment | Posted in Programming |