Snap To Pixel In Photoshop

While using guides or the rectangle marquee tool you can have the box snap to pixels by holding down the SHIFT key.

ASP.NET Evaluated Inline Expressions

<%if(DateTime.Now < DateTime.Parse("7/1/2010 1:00 AM")) {	%>
            <img class="subh" alt="Before July" src="/image.gif" />
		<%}else {%>
            <img class="subh" alt="July and after" src="/image2.gif" />  
<%}%>

Reset Primary Column ID in Table

This will reset the primary column id number to 0, so the next time something is added it will have primary key id = 1

DBCC CHECKIDENT('YourTableName', RESEED, 0)

Useful in cases where you are doing a .. SET @NewID = SCOPE_IDENTITY() and a new ID is generated which you would like to reset.

Reference: MSDN – DBCC CHECKIDENT