Get started
Bring yourself up to speed with our introductory content.
SQL Server Database Modeling and Design
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 on the hard drive of a computer. (Continued)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
FAQ: SQL Server 2005 features and functions
SQL Server 2005 is full with new features and functions. Get the answers to 10 frequently asked questions on the minds of DBAs and developers about major DBMS changes and new functionality.Continue Reading