SQL Server Database Modeling and Design

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Microsoft Master Data Services boosts SQL master data management

    With all the excitement around new gadgets in the upcoming release of SQL Server, code-named Denali, it’s easy to forget how much Microsoft played up features in its current version. SQL Server Insider did some digging around in SQL Server 2008 R2 an... 

  • 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. 

  • AdventureWorks Database

    AdventureWorks Database is a sample OLTP database that Microsoft ships with all of its SQL Server database products. 

  • 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) 

  • multidimensional expressions (MDX)

    multidimensional expressions (MDX) 

  • 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 ... 

  • flat file

    A flat file is a file containing records that have no structured interrelationship. 

  • C++

    C++ is an object-oriented programming (OOP) language that is viewed by many as the best language for creating large-scale applications. 

  • 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. 

  • Database: Glossary

    This is a glossary of database-related terms. 

  • 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...... 

  • See more Definitions on SQL Server Database Modeling and Design
About SQL Server Database Modeling and Design

A database model is exactly what is sounds like - the structural format of the database. An accurate and up-to-date data model can help SQL Server administrators to create high-performance applications from the get-go and better meet the needs of end users. Common database models include hierarchical, network and relational models. This topic page features the design tips and modeling tools that administrators need to create a successful data model and design an effective database for Microsoft SQL Server.