Sending an email to new employees

Here is a simple little tip:

If you wanted to email a new guy in your company, you know that he should be found in Exchange’s Global Address List, If you haven’t emailed him before, and Outlook’s auto-suggest name list doesn’t appear to recognise the name (you know the one that pops up as you start typing in the “To” field), you can just start typing then press the Ctrl + K.

[Figure 1 - No popup name list for suggestions to contacts containing "s". Generally means you haven’t contacted anyone with a contact name containing “s”]
This will either complete the name for you or (if there are multiple people with the same first letters) it will pop up a filtered address list for you to select like shown below:

[Figure 2 - Found multiple contacts containing "s" in the Global Address List]

Activity Monitor in MSSQL Management Studios 2008

Microsoft seemed to have moved the Activity Monitor from its original location in SQL 2005 to a new one in SQL 2008
It used to be here:



Now it is here:


[Figure 2 - Right-click Database Node > Activity Monitor]

It actually looks a lot like the Windows Task Manager.


[Figure 3 - Windows Task Manager style Activity Monitor.]

This makes it so much easier for you to find out if there are any exclusive locks being made on important queries you are running or even whether or not there are processes eating up the server with query processing.