How to Design, Create, and Maintain a SQL Server Database

How to Design, Create, and Maintain a SQL Server Database

Intended audience: Application developers who are not familiar with designing, implementing or maintaining databases, yet need to create a database for use with their applications.

The links below are external links and provide information and guidance on understanding how to design, create and maintain databases using SQL Server, as well as avoiding common mistakes during database design.

 This topic is a how to.
Please keep it as clear and simple as possible. Avoid speculative discussions as well as a deep dive into underlying mechanisms or related technologies.

 
 

Overview Information

Database Design

A well thought out database design will reduce data storage requirements by normalizing data, increase performance through organization and indexing of data, and will generally help you avoid revisiting and redesigning your database multiple times during application development. Ten Common Database Design Mistakes provides a list of ten of the more common design mistakes, as well as the consequences of these mistakes. The other links in this section provide additional resources to help you successfully design the database(s) used by your application.

Design Optimization

Maintenance

Transact-SQL (T-SQL)

T-SQL is the query language used to communicate with, and act upon, the data contained within a SQL Server database. While there are other ways to interact with this data from within an application, such as LINQ, for most interactions with the database you will be required to use T-SQL.

Data-Tier Applications (DAC) - SQL Server 2008R2 Only

A data-tier application (DAC) is an entity that contains all of the database and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects instead of having to manage them separately.

Samples


See Also

 



Other Languages

This article is also available in the following languages:

Italian (it-IT)

Português (pt-BR)

Japanese (ja-JP)

Español

Leave a Comment
  • Please add 7 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Naomi  N edited Revision 24. Comment: Added a good link, in my opinion

  • Samuel Lester - MSFT edited Revision 23. Comment: Fixed small typo

  • Carsten Siemens edited Revision 22. Comment: Added tags: has comment, has TOC

  • FZB edited Revision 21. Comment: removed (en-US) from title according to latest wiki guidelines, language tag is present in tags

  • Richard Mueller edited Revision 20. Comment: Removed zero from <a name> tag of heading in HTML so TOC works

  • Monica Rivera edited Revision 19. Comment: Added link to spanish page.

  • Ed Price - MSFT edited Revision 16. Comment: White space formatting

  • Jewel Lambert edited Revision 15. Comment: corrected spelling typo

  • Luan.Moreno - SQL Soul edited Revision 13. Comment: Add Language portuguese in Other Languages

  • FZB edited Revision 12. Comment: space

Page 1 of 2 (16 items) 12
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Larry Franks edited Original. Comment: added text to database design

  • Ed Price MSFT edited Revision 1. Comment: Clarified the links are external.

  • Thanks for this wiki.

    I wrote a post on elmozamil.blogspot.com about store procedure to make my application in layers, I mean if I have stored procedure for my logic, and application, and tables, views. isn't make my application more manageable and adaptable for changes.

    I hope get an answer.

  • Luigi Bruno edited Revision 7. Comment: Edited article's title and tags list. Added the "Other Languages" section.

  • Pantelis44999 edited Revision 8. Comment: Added How To Template message

  • FZB edited Revision 10. Comment: typo

  • FZB edited Revision 11. Comment: typo

  • FZB edited Revision 12. Comment: space

  • Luan.Moreno - SQL Soul edited Revision 13. Comment: Add Language portuguese in Other Languages

  • Jewel Lambert edited Revision 15. Comment: corrected spelling typo

  • Ed Price - MSFT edited Revision 16. Comment: White space formatting

  • Monica Rivera edited Revision 19. Comment: Added link to spanish page.

  • Richard Mueller edited Revision 20. Comment: Removed zero from <a name> tag of heading in HTML so TOC works

  • FZB edited Revision 21. Comment: removed (en-US) from title according to latest wiki guidelines, language tag is present in tags

  • Thanks for such a nice  wiki

Page 1 of 2 (18 items) 12