.NET Data story (MSSQL, MS SQL Express, SQL Compact, TSQL, LINQ, EF)

Entity Framework (EF)

Sync Framework

SQL Server 2008

ADO.net

Database stuff

SQL Server

nHibernate - ORMs

SQL Server 2008 Express manager

T-SQL

LINQ

//Return the top 10 most frequently occurring words in a string.
    var words = s.Split(' ');
    var wordCounts = words.GroupBy(x => x).Select(x => new { Name = x.Key, Count = x.Count() }).OrderByDescending(x => x.Count);  
    var countedWords = wordCounts.Select(x => x.Name).Take(10).ToList();

SQL Compact, SQLCE

SQLCE identity columns and EF

SQL Server Compact DLLs

asp.net dynamic data services (astoria)

Reports (ssis and rdlc)

TSQL / MSSQL specifics

USE MASTER;
sp_addLogin 'user','pass','defdatabase';
sp_addsrvrolemember 'user','sysadmin';
use yourdb;
exec sp_adduser 'user';

object hierarchies

OData

SQL Server Performance tuning