Database

Normal Forms

    • A Simple Guide to Five Normal Forms in Relational Database Theory (link)

Clustered vs Non-Clustered Index

    • What is the difference between clustered and nonclustered indexes? (link)
    • Clustered index vs. non-clustered index (link)
    • An Introduction to Clustered and Non-Clustered Index Data Structures (link)

Joins

Outer Join

    • Using Outer Joins (link), MSDN

Relational Databases

SQLite

SQLite page.

SQL Server

To delete records from the table and also reset the Identity field, use

truncate table [schema].[Table]

SQL Server list of updates (link). Lists service packs and any cumulative patches released.

SQL Compact

SQL Compact is Microsoft's parallel to SQLite. It is a small database engine that can be used both on desktop and on mobile devices.

Utilities

See Database Tools page for tools.