Sharing a common AssemblyInfo between projects in a solution

Here is a good article 

http://weblogs.asp.net/srkirkland/simple-msbuild-configuration-updating-assemblies-with-a-version-number

See sections:

Create CommonAssemblieInfo.cs

Cleanup AssemblyInfo.cs & Link ComonAssemblyInfo.cs

How to examine cached execution plan

Use sys.dm_exec_cached_plans

SELECT top 10 UseCounts, Cacheobjtype, Objtype, TEXT, query_plan
FROM sys.dm_exec_cached_plans
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
CROSS APPLY sys.dm_exec_query_plan(plan_handle)

T-SQL tools

Excellent SQL search tool, that allows to search for all objects, sp, views, tables and so on

SQL Search
http://www.red-gate.com/products/sql-development/sql-search/ 

SSMS Tools.
SQL History that store history of all run scripts.
http://www.ssmstoolspack.com/Download 

How to view Windows Handles and GDI Objects used by process?

Open Task Manager
Choose tab Processes
Select column Handles and GDI Objects from menu View

How to which security groups I belong?

Run the following command

gpresult /v

Look for section

The user is a part of the following security groups

Also

whoami /groups

Links to interview quiestions

New interview questions for Senior Software engineers