After releasing Office 2007 SP2, Microsoft has unveiled screenshots for Office 2010. Like all previous versions Office 2010 will also introduce UI innovations but the most interesting thing about Office 2010 is that most Office Suite applications will also have a corresponding web application. In simple terms this means that we will be able to [...]

What is the first thing you do when you open the control panel in Windows Vista? I always switch it to Classic View and most people I know do the same. Microsoft got it so right with the Classic View and I cannot understand whey they are trying to convince people to move away from [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

I’ll be honest that I was not much excited about Internet Explorer 8 until it went RTM. There is only so much beta software one can take. But today when IE8 went RTM I decided to install it on my main machine. This post talks about my first experience with the browser.
Installation of IE8 [...]

To find out the space used by a table we can use sp_spaceused procedure. Most of the times sp_spaceused will give correct information. Why do I say most of the time? Well consider this example. I just inserted a large amount of data in Orders table in Northwind database and ran sp_spaceused.
EXEC sp_spaceused ‘Orders’
which returns [...]

The title says it all.
Here is the Link.

Every object in SQL Server database has an Object Id which is used extensively by SQL Server for most operations. There are times when we would like to know what the object ID is for a particular object. In this example I will show you two ways to retrieve Object Id. My examples will retrieve [...]