Get started
Bring yourself up to speed with our introductory content.
SQL Server Database Modeling and Design
database normalization
Database normalization is intrinsic to most relational database schemes. It is a process that organizes data into tables so that results are always unambiguous. Continue Reading
data mart (datamart)
A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers. Continue Reading
AlwaysOn Availability Groups
AlwaysOn Availability Groups is a database mirroring technique for Microsoft SQL Server that allows administrators to pull together a group of user databases that can fail over together. Continue Reading
-
AdventureWorks Database
AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products. Continue Reading
SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT
In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading
database replication
Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of information... (Continued)Continue Reading
multidimensional expressions (MDX)
multidimensional expressions (MDX)Continue Reading
Top reasons to get started with SQL Server Denali
The upcoming SQL Server Denali is chock-full of new features, such as super-fast column-store indexes and a new Web-based reporting tool. But what does it mean for businesses?Continue Reading
tablespace
In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usually two or more. In a database, a tablespace plays a role similar to that of a folder...Continue Reading
flat file
A flat file is a file containing records that have no structured interrelationship.Continue Reading
-
C++
C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications.Continue Reading
ActiveX Data Objects (ADO)
ActiveX Data Objects (ADO) is an application program interface from Microsoft that lets a programmer writing Windows applications get access to a relational or non-relational database from both Microsoft and other database providers.Continue Reading
Database: Glossary
This is a glossary of database-related terms.Continue Reading
database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued.....Continue Reading
data structure
A data structure is a specialized format for organizing and storing data.Continue Reading