Intersect, Except, Union, All and Any

This article examines some of the little used T-SQL items function and see if they work for you

reade more

http://www.sqlservercentral.com/articles/T-SQL/67545/

cheers
Samitha

INSERT, UPDATE and DELETE against a Database Snapshot

This article demonstrates that it is possible to run an INSERT, UPDATE or DELETE against a Database Snapshot. 

http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/10/17/successfully-execute-an-insert-update-and-delete-against-a-database-snapshot.aspx

cheers
Samitha

URL Redirect Checker

When the amount of links on your site begin to grow, you'll be faced with all sorts of dead links, structure changes and more. It's important that you provide as many re-directs as you can when this happens, and that they work. Use this URL Redirect Checker to check any re-direct link.

cheers,
Samitha

Visual Studio 2011 Developer Preview

Check out the new features and functionalities in the developer preview.

http://msdn.microsoft.com/en-us/vstudio/hh127353

Cheers,

Samitha

Download Microsoft SQL Server 2012 Release Candidate (RC)

Experience the full value of SQL Server 2012 now. The release candidate is a production-quality release that gives you the chance to download, preview, and deploy the full marquee capabilities being delivered in SQL Server 2012.

http://technet.microsoft.com/en-us/evalcenter/hh225126.aspx?prod=SQL%25tech=CL%20%25type=DL%25prog=eval 

Cheers,
Samitha