Introduction to the Relational Model and ANSI SQL

Relational database management systems (RDBMS) such as those covered on this website are the principal engines of structured data systems worldwide. They enable a multitude of users to quickly and simultaneously access, create, edit, and manipulate data without impacting other users. And they enable developers to write useful applications to access their data while providing administrators with the consistent and reliable capabilities they need to maintain, secure, and optimize organizational data resources. An RDBMS may be defined as a system whose users view data as a collection of tables … [Read more...]

Video: Data Modeling in the SQL Server Space

Join SQL Server MVP and President of PASS, Kevin Kline as he: * Identifies the issues that can arise from relying only on modeling tools * Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical * Describes how to correctly identify and resolve serious problems * Provides best practices to resolve issues Posted June 14, 2007. … [Read more...]