MS SQL Server Express - Re-learn

Useful Links

I refer to the book Sams Teach Yourself Microsoft® SQL Server™ 2005 Express in 24 Hours, By Alison Balter

Ch 1, 2. Introduction to SQL Server, Server Baiscs

System databases include Master, Model, MSDB, Resource, TempDB, and Distribution, they are part of the system.

Six versions of SQL Server 2005

SQL Server Management Studio Express

SQL Server Management Studio Express is the tool that you use to manage your SQL Server and its objects. Using this tool, you can create and work with databases, tables, stored procedures, indexes, and much more!

In short, before you can even start a ASP.NET database connection, I recommend you to do the following... (or else you are just a handicapped Visual Studio Programmer who do not know how to migrate your database.)

1. Install MS SQL Server Express 2005

2. Install MS SQL Server Management Studio Express


Ch 3. Microsoft SQL Server Management Studio Express

Databases Node

Security Node

Server Objects

The Replication Node
Data replication is the capability of a system to make copies of its data and application objects automatically in remote locations.



The reset of the chapters are quite simple if you know Relational Database stuff... just need to play with the interface.