Alen's IT

Search this site

My Web Sites

Recent site activity

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

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.

NoSQL

For a comprehensive list check NOSQL site (link) or Wikipedia page on the topic (link).
  • Cassandra
  • CouchDB
  • HBase
  • Membase
  • MongoDB
  • RavenDB
    • Intro to RavenDB (link)
  • Redis
Quick overviews of the above technologies: 1 (link)
Subpages (7): Database Tools Entity Framework MongoDB NHibernate OData SQLite SQL Server Compact

Sign in|Recent Site Activity|Report Abuse|Print Page|Remove Access|Powered By Google Sites