StyleCop

StyleCop analyzes C# source code to enforce a set of style and consistency rules.

Learning ASP.NET's MVC Framework

Here's a post on how to learn the ASP.NET MVC Framework the "easy way".

SQL Queries and Wasting Memory

This is an article explaining why using non-parameterized ad-hoc queries to get data from SQL Server may not be a good idea.

From Technet, here is a document titled "SQL Server 2008 Upgrade Technical Reference Guide".

SQL Server Indexing

Here is a good post covering the basics of SQL Server indexing and here is another on determining if your existing indexes are being used effectively.