SQL CURRENT_TIMESTAMP vs GETDATE() Great Article.

http://blog.sqlauthority.com/2012/12/20/sql-server-difference-between-current_timestamp-and-getdate-current_timestamp-equivalent-in-sql-server/

How to clear the Immediate Window

Simply type >cls

Source Control disappear from Solution Explorer Visual Studio 2010

Check - Visual Studio, click on File-->Source Control-->Change Source Control.

Windows 7 add shortcut to Active Directory

Create a short cut and point to -  %SystemRoot%\SYSTEM32\rundll32.exe dsquery,OpenQueryWindow

Entity Container Name Gotcha

Was coding today in an application I support currently (Very large)...

Lesson learned --- When working with .edmx (Entity Framework)

1) Always ensure the project for the entity framework is a reference in your current project you need to use the entities for.

2)  When using the "Using" statement create as follows:

'Note I shortcut contact with ctx

Using ctx As New nameOfEntity()  ' Here is the key to this lesson nameOfEntity is the "Entity Container Name" listed under the properties for the .edmx model.

Very important.    Remember this one.